software

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?
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--
Regards,

Peo Sjoblom

(No private emails please)quot;Jayequot; gt; wrote in message
news
gt; Can anyone provide a formula to take a time value in one column (A1) and
gt; subtract 2 hours to show central time (B1) and subtract 3 hours to show
gt; pacific time (C1)?
gt;
gt; Also, how should A1, B1, and C1 be formatted?
gt;ok, thanks. i'll give that a try.

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

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; Formatted as time, don't know what you mean by central time, as far as I
gt; know central time is 1 hour less than est, mountain is 2 and pacific is 3,
gt; so to cope with times like 01:00 AM use in B1 (assuming that A1 is eastern
gt; time)
gt;
gt; =MOD(A1-(1/24),1)
gt;
gt; for central
gt;
gt; =MOD(A1-(2/24),1)
gt;
gt; mountain
gt;
gt; =MOD(A1-(3/24),1)
gt;
gt; pacific
gt;
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; (No private emails please)
gt;
gt;
gt; quot;Jayequot; gt; wrote in message
gt; news
gt;gt; Can anyone provide a formula to take a time value in one column (A1) and
gt;gt; subtract 2 hours to show central time (B1) and subtract 3 hours to show
gt;gt; pacific time (C1)?
gt;gt;
gt;gt; Also, how should A1, B1, and C1 be formatted?
gt;gt;
gt;
Just add it instead

--
Regards,

Peo Sjoblom

(No private emails please)quot;Jayequot; gt; wrote in message
...
gt; ok, thanks. i'll give that a try.
gt;
gt; how about converting in the quot;other direction,quot; meaning pacific to eastern
gt; or central to eastern?
gt;
gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; ...
gt;gt; Formatted as time, don't know what you mean by central time, as far as I
gt;gt; know central time is 1 hour less than est, mountain is 2 and pacific is
gt;gt; 3, so to cope with times like 01:00 AM use in B1 (assuming that A1 is
gt;gt; eastern time)
gt;gt;
gt;gt; =MOD(A1-(1/24),1)
gt;gt;
gt;gt; for central
gt;gt;
gt;gt; =MOD(A1-(2/24),1)
gt;gt;
gt;gt; mountain
gt;gt;
gt;gt; =MOD(A1-(3/24),1)
gt;gt;
gt;gt; pacific
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; (No private emails please)
gt;gt;
gt;gt;
gt;gt; quot;Jayequot; gt; wrote in message
gt;gt; news
gt;gt;gt; Can anyone provide a formula to take a time value in one column (A1) and
gt;gt;gt; subtract 2 hours to show central time (B1) and subtract 3 hours to show
gt;gt;gt; pacific time (C1)?
gt;gt;gt;
gt;gt;gt; Also, how should A1, B1, and C1 be formatted?
gt;gt;gt;
gt;gt;
gt;
gt;