dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
371
share rss forum feed

slajoh01

join:2005-04-23

[Excel] Timezone Help

I have to do some military reports in excel, and I must need to use the ZULU TZ format.
I am using the =NOW() which is OK and I can format the times as needed. So, if an offset of +2 UTC, how would this be in a formula?

Thanks in advance



brianmcd
Premium
join:2000-09-06
Norristown, PA

=NOW() - TIME(2,0,0)