Need to add time +2 hours

[sksanjeev786]

Hi Team,

I would like to add +2 hours if my starting 9:00 AM till 11:00 PM

example
9:00AM
11:00AM
1:00PM

 

[etaf]

how about
=IF(AND(A2>=TIME(9,0,0),A2<=TIME(23,0,0)),A2+TIME(2,0,0),A2)

Book11
	A	B
2	9:00	11:00
3	11:00	13:00
4	13:00	15:00
5	23:30	23:30
6	8:00	8:00
Sheet1

Cell Formulas
Range	Formula
B2:B6	B2	=IF(AND(A2>=TIME(9,0,0),A2<=TIME(23,0,0)),A2+TIME(2,0,0),A2)

 

[sksanjeev786]

how about
=IF(AND(A2>=TIME(9,0,0),A2<=TIME(23,0,0)),A2+TIME(2,0,0),A2)

Book11
	A	B
2	9:00	11:00
3	11:00	13:00
4	13:00	15:00
5	23:30	23:30
6	8:00	8:00
Sheet1

Cell Formulas
Range	Formula
B2:B6	B2	=IF(AND(A2>=TIME(9,0,0),A2<=TIME(23,0,0)),A2+TIME(2,0,0),A2)

Perfect..!!! Thank you so much..

 

[etaf]

you are welcome