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?
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)
"Jaye" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
ok, thanks. i'll give that a try.
how about converting in the "other direction," meaning pacific to eastern or
central to eastern?
"Peo Sjoblom" <[email protected]> wrote in message
news:[email protected]...
> 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)
>
>
> "Jaye" <[email protected]> wrote in message
> news:[email protected]...
>> 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?
>>
>
Just add it instead
--
Regards,
Peo Sjoblom
(No private emails please)
"Jaye" <[email protected]> wrote in message
news:[email protected]...
> ok, thanks. i'll give that a try.
>
> how about converting in the "other direction," meaning pacific to eastern
> or central to eastern?
>
> "Peo Sjoblom" <[email protected]> wrote in message
> news:[email protected]...
>> 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)
>>
>>
>> "Jaye" <[email protected]> wrote in message
>> news:[email protected]...
>>> 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?
>>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks