time zones

C

Cactus-747

I want to make A1 “zulu time”, so with ESD time in cell B1, I put the
formula: =(B1+5/24) in A1.

Now I want to be able to make cell C1 Central time, D1 Mountain time,
and E1 Pacific time. I would obviously only use one respective time
zone for entry or I reckon I would get a value error. I thought the
formula would be something like:
=(B1+4/24)AND(C1+5/24)AND(D1+6/24)AND(E1+7/24). But that doesn’t work.
Any idea’s?
 
J

John James

Enter your base time into cell B1. If you want the current time, enter
=now(

Enter the text ESD, Zulu, Central, Mountain, and Pacific into cells B2
C2, D2, E2 and F2 respectivel

Enter the desired time differences into row 2 - i.e. type 0, 4, ..
etc into cells B3, C3, D3, E3 and F3 respectively (whatever thes
differences are

In cell B3 enter the formula
=$B1+B2/2
Copy this formula to the right across all cells in your table in row

Choose your preferred cell formatting. Move cells to your preferre
position
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top