Subtracting Hours - Eastern to Pacific/Central

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jaye - 18 Dec 2005 02:38 GMT

Can anyone provide a formula to take a time value in one column (A1) and
subtract 2 hours to show central time (B1) and subtract 3 hours to show
pacific time (C1)?

Also, how should A1, B1, and C1 be formatted?

Reply to this Message

Peo Sjoblom - 18 Dec 2005 02:48 GMT

Formatted as time, don't know what you mean by central time, as far as I
know central time is 1 hour less than est, mountain is 2 and pacific is 3,
so to cope with times like 01:00 AM use in B1 (assuming that A1 is eastern
time)

=MOD(A1-(1/24),1)

for central

=MOD(A1-(2/24),1)

mountain

=MOD(A1-(3/24),1)

pacific

Signature

Regards,

Peo Sjoblom

(No private emails please)

> Can anyone provide a formula to take a time value in one column (A1) and
> subtract 2 hours to show central time (B1) and subtract 3 hours to show
> pacific time (C1)?
>
> Also, how should A1, B1, and C1 be formatted?

Reply to this Message

Jaye - 18 Dec 2005 04:01 GMT

ok, thanks. i'll give that a try.

how about converting in the "other direction," meaning pacific to eastern or
central to eastern?

> Formatted as time, don't know what you mean by central time, as far as I
> know central time is 1 hour less than est, mountain is 2 and pacific is 3,
[quoted text clipped - 18 lines]
>>
>> Also, how should A1, B1, and C1 be formatted?

Reply to this Message

Peo Sjoblom - 18 Dec 2005 08:12 GMT

Just add it instead

Signature

Regards,

Peo Sjoblom

(No private emails please)

> ok, thanks. i'll give that a try.
>
[quoted text clipped - 23 lines]
>>>
>>> Also, how should A1, B1, and C1 be formatted?

Reply to this Message