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?
<tbody>
</tbody>
Converted to EST
Time Conversion is understood.
Any idea on how to convert date if time change changes the date?
<tbody>
</tbody>
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>