Changing CST to EST - PLUS DATE CHANGE - Suggestions?

[kescco]

I know that placing 03:00:00 in a cell, copying it, and then Paste Special - Add will update the times.

My questions is how would you change the date in another column if the added three hours changes the date?

Date	Time CST
09-24-2014	22:00:00
09-25-2014	22:30:00

<tbody>
</tbody>

Converted to EST
Time Conversion is understood.
Any idea on how to convert date if time change changes the date?

Date	Time EST
09-25-2014	01:00:00
09-26-2014	01:30:00

<tbody>
</tbody>

 

[shg]

Put the date and time in the same cell -- which you can do easily by copying the time column, Paste Special > Add to the date column, and then reformatting to show date and time.

 

[kescco]

Works very nicely. Another way if someone wants to use a formula might be something like:

IF(AND(B1 >= TIME(0,0,0), B1 < TIME(3,0,0)), SUM(DATEVALUE(C2),1), C2)

This is assuming the time is in Column B and the date in Column C.

Thank you for your help.

 

[shg]

You're welcome.