Excel 2003 convert hours from GMT to PST??

G

Gregg Hill

Hello!

I have a huge log file that has time in hh:mm:ss GMT and I want to convert
those time to PST. I need to subtract 8 hours from the GMT time, but I
cannot figure out how to do it.

Any ideas?

Thank you!

Greg Hill
 
P

Peo Sjoblom

I would use a help column, assume the times are truly numeric and not text

=A1-8/24

where A1 holds the GMT, you might get a pseudo date so format result as
hh:mm

another way (less attractive if you make a mistake since there are no audit
trails except undo)

put =8/24 in a cell, format the cell as time,copy it, select all dates, do
edit>paste special and select subtract

--
Regards,

Peo Sjoblom

Portland, Oregon
 
P

Peo Sjoblom

Try this instead

=MOD(A1-8/24,1)

so you don't get negative time ###############

--
Regards,

Peo Sjoblom

Portland, Oregon
 
G

Gregg Hill

Peo, YOU
RULE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

OK, no how can I quickly make it fill from the start point to the end of the
column, about 38,000 lines?

Gregg Hill
 
P

Peo Sjoblom

Assume the values are in A2:A38002, assume you put the formula in B2
select B2 after you have put the first formula there, move the mouse pointer
to the lower
right corner of B2, when the "fat" cross changes to a "thin" cross, double
click the mouse and the formulas
should copy down as long as you have values in the adjacent column to the
left

Another way, select B2, in the name box above column A's header (where you
see the address of the active cell)
type B2:B38002 then press enter, then press ctrl + D

--
Regards,

Peo Sjoblom

Portland, Oregon
 
G

Gregg Hill

Peo,

Dang, you're good! That was WAY too easy.

Thanks again for the help. Time to go get an Excel for Dummies book.

Gregg Hill
 
Top