Create Problem Time Addition

Question

i have a scenario that i need to add time.

for example time is 11:50 pm and i need to add 30 minutes. So after addition it should show me 00:20 am with date.

write a code for this.

i tried this but i get a error after adding.

after addition it is showing me something like 1.00:20:00.

so i need to convert this to date time.

 

Select		Stop	Type	Address	Arrival	Waiting(Min)	Departure	Traval(Min)
		CZCZ	CP	ZZC	8:00PM	60	9:00PM	0
		ZCZC	CP	CVZVZ	9:00PM	20	9:20PM	10
		CZZGVZ	CP	VZXVZV	9:30PM	10	9:40PM	20
		asgdsag	CP	sdgsdg	10:00PM	10	10:10PM	20
		ZCCZZ	CP	ZCZCZC	10:30PM	60	11:30PM	0
		CZCZ	CP	ZCZCC	11:30 PM	5	11:35 PM	5
		ZCZC	CP	ZVZVZ	11:40 PM	10	11:50 PM	10

 

Arrival Time + waiting time = Departure Time 

and

Departure + Traval =  Next Arrival Time