UTC time to Central Time (US)

[C C]

Hello.

I need to convert UTC time to US Central Time Zone.
The date is in one column and the time is in another below.


A | B
----------------------------------
Date | Time
----------------------------------
2005-10-24 | 12:15:00

I want to convert the Date and Time columns in UTC
to a single Date and Time column in US Central
Time.

Thanks for any advice

 

[Peo Sjoblom]

Assuming UTC is the same as GMT then the difference is 6 hours STD,

so if the time is 06:00 AM it is 12:00 PM GMT, thus add 6 hours and since
the y are all numbers just add

=A1+B1+(6/24)

format as m/d/yy h:mm or m/d/yy h:mm AM/PM

where A1 holds the date and B1 the time

 

[C C]

Thanks so much. That did it.

But it should be =A1+B1-(5/24) for US Central
Time during summer time.
Please note the minus instead of plus.

 

[Peo Sjoblom]

You didn't mention anything about daylight savings