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