Mountain Time To Zulu

Zulu to mdt
  1. Universal Time and Mountain Standard Time Converter Calculator, UTC and MST Conversion Table.
  2. 'Zulu' time, more commonly know as 'GMT' ( Greenwich Mean Time ) is time at the Zero Meridian.Our natural concept of time is linked to the rotation of the earth and we define the length of the day as the 24 hours it takes (on average) the earth to spin once on its axis.

Zulu To Mdt

May 4th 09, 01:25 PMposted to microsoft.public.excel.misc
external usenet poster
Posts: 37
FORMATTING/CONVERTING TO ZULU TIME
Hi Mike,
Thanks for the quick reply. I'm pretty much self taught..so, needless to
say, I'm green and almost need to be held by the hand through this one.
My columns are F & G. So, I highlight the 2 columns, go under conditional
formatting, formula is and then do I replace your 'A' with F? Do I format 1
column at a time? I don't have seconds in my time. I basically have for
example.. 0645, 1815, 1430 etc.. Thanks again for your help.
MM
'Mike H' wrote:

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

Where Is Zulu Time

Corporate number for jiffy lube. The US/Mountain time is now 17:-04-29. $50 off web hosting! Zulu Eastern Central Mountain Pacific More. Current local time in a clear format. The US/Mountain time is now 17:-04-29. $50 off web hosting! Zulu Eastern Central. The 12 time zones East of the Zulu time zone (GMT) starting from Zulu and ending at the International Date Line in the Pacific Ocean are Alpha through Mike. Mike and Yankee zones are the same time but a day apart, on either side of the International Date Line. Zulu time is the military term for Greenwich Mean Time. It is the time in Greenwich, England. So if you are underway on a ship at sea, and all of the Navy uses GMT, if you say, 'at 1900 hrs Zulu.