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 respectively
Enter the desired time differences into row 2 - i.e. type 0, 4, ...
etc into cells B3, C3, D3, E3 and F3 respectively (whatever these
differences are)
In cell B3 enter the formula
=$B1+B2/24
Copy this formula to the right across all cells in your table in row 3
Choose your preferred cell formatting. Move cells to your preferred
positions
--
John James
------------------------------------------------------------------------
John James's Profile:
http://www.excelforum.com/member.php...o&userid=32690
View this thread:
http://www.excelforum.com/showthread...hreadid=532869