UTC Excel conversion

  • Thread starter Thread starter GerryK
  • Start date Start date
G

GerryK

Hi,
Does anyone have a formula or macro that would convert
time in Excel (from CST and daylight savings time) to
curret UTC time.

Example, In A1 I would like to put Today () with 9:00 a.m.
and have the coordinated unversal time show 06. I'm having
a problem with previous day calculations. (ie. 6 p.m. on
the previous day is 00 UTC)

Any military folks out there?

TIA
 
Try:

=NOW() + TIME(6,0,0)

Format it to display date, time or both. You can change it at 02:00 am
local on Sunday morning to

=NOW() + TIME(5,0,0)

unless you're in the portion of Indiana that stays on CST.

Note that at 9:00 am CST, UTC is 3:00 pm, not 6:00 pm

and format as date.In article <[email protected]>,
 
Back
Top