View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default FORMATTING/CONVERTING TO ZULU TIME

Hi,

Eastern, Mountain(Mountain??) and central time will all be offset from Zulu
by an amount of hours so for each column use this with the hours (Plus/minus)
suitably adapted and drag down.

=TIME(HOUR(A1)-6,MINUTE(A1),SECOND(A1))

Mike

"MM" wrote:

Does anyone know how to format or convert a column of times
(eastern/mountain/central etc....) all to zulu time?
I'm currently using Excel 2003.
Thanks,
MM