Re: Convert between UTC and EST times

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 03/21/04 

Date: Sun, 21 Mar 2004 07:55:59 -0700

Works for me.

I've gotten used to using this form, though:

B2: =MOD(A2-C2/24,1)
E2: =MOD(D2+C2/24,1)

In article <405da5c2$0$13661$afc38c87@news.optusnet.com.au>,
 "Norman Harker" <njharker@optusnet.com.au> wrote:

> Hi JE!
>
> Thanks and Agreed! Obviously you get used to handling these problems
> being a Mac user!
>
> Trying to get a generic solution to conversions to and from Zulu
>
> A1: Local
> B1: UTC
> C1: Difference in decimal hours
> D1: UTC
> E1: Local
>
> A2: User Entry
> B2:
> =A2-C2/24+((A2-C2/24)<1)
> C2: User Entry
> D2: User Entry
> E2:
> =D2+C2/24+((D2+C2/24)<1)
>
> I've tested and it appears OK but confirmation would be appreciated.
> (They'll be a lot of clock questions coming up as we change clocks
> next weekend).

Quantcast