Hi Fred,
Thanks for the tips on posting "clarity".
Column F is a start time, and G is the end time. The Zulu time will change
from "office" to "office".
Ok, now this part I'm stumped.... how am I supposed to add the formula if
not using conditional formatting? Example:
0700
0840
1035
I have to get these numbers (and others in the column) to change to zulu time.
Thanks so much,
MM

"Fred Smith" wrote:

As you've found out, if you want responders to show you the exact formula
you need, then identify the cells you are using in your initial post.
Otherwise, we can only generalize, and tend to use A1 to show the way.

In this post, you talk about conditional formatting. Where did that come in?
I don't see how conditional formatting is going to do what you want.

You say your columns are F and G. What's in F, and what's in G? Do you mean
you have a time in F, and you want to convert it to Zulu in G? If so, apply
Mike's formula (in G1) like:
=time(hour(f1)-6,minute(f1),second(f1))

As you haven't told us what time zone you're using, only you can determine
how many hours you need to subtract (or add) to convert to Zulu.

Do you format 1 column at a time? No. Enter the formula in the first cell in
the column. Format it the way you want. Then copy it down the column (using
the fill handle is the easiest way). The formatting will be copied at the
same time.

Regards,
Fred.


"MM" wrote in message
...
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