In Excel, I want to convert Eastern time to pacific time

  • Thread starter Thread starter Guest
  • Start date Start date
There's probably a more efficient way to do this, but I so rarely use Times
in my work, I'm not sure. But if you're just working with Time and not
Dates, this works:

=TIME(IF(HOUR(A1)<3,21+HOUR(A1),HOUR(A1)-3),MINUTE(A1),SECOND(A1))

HTH,
Elkar
 
Can't you just subtract 3 from the hour value?



Example. Say cell A1 has Eastern time. You want cell b4 to reflec
pacific time.

In cell b4 enter "=A1-3"


Or, you could just move to California
 
Try something like this:

For a time in A1
B1: =A1-3*1/24

The cells must be formatted as Time to display correctly.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Ron said:
Try something like this:

For a time in A1
B1: =A1-3*1/24
Click to expand...

But you'll have a problem with this if, for instance A1 contains the
time 02:00

Try

=MOD(A1-"03:00",1)
 
Back
Top