Re: Subtracting Hours - Eastern to Pacific/Central
- From: "Jaye" <jayecavallo@xxxxxxxxxxx>
- Date: Sat, 17 Dec 2005 23:01:09 -0500
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" <terre08@xxxxxxxx> wrote in message
news:Op5BK23AGHA.2560@xxxxxxxxxxxxxxxxxxxxxxx
> 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" <jayecavallo@xxxxxxxxxxx> wrote in message
> news:oY3pf.525$DM5.436@xxxxxxxxxxx
>> 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?
>>
>
.
- Follow-Ups:
- Re: Subtracting Hours - Eastern to Pacific/Central
- From: Peo Sjoblom
- Re: Subtracting Hours - Eastern to Pacific/Central
- References:
- Subtracting Hours - Eastern to Pacific/Central
- From: Jaye
- Re: Subtracting Hours - Eastern to Pacific/Central
- From: Peo Sjoblom
- Subtracting Hours - Eastern to Pacific/Central
- Prev by Date: RE: Including objects based on a condition
- Next by Date: Query
- Previous by thread: Re: Subtracting Hours - Eastern to Pacific/Central
- Next by thread: Re: Subtracting Hours - Eastern to Pacific/Central
- Index(es):
Relevant Pages
|
