Excel 2003 convert hours from GMT to PST??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gregg Hill - 09 Feb 2006 01:44 GMT

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

Reply to this Message

Peo Sjoblom - 09 Feb 2006 01:57 GMT

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

Signature

Regards,

Peo Sjoblom

Portland, Oregon

> Hello!
>
[quoted text clipped - 7 lines]
>
> Greg Hill

Reply to this Message

Peo Sjoblom - 09 Feb 2006 02:07 GMT

Try this instead

=MOD(A1-8/24,1)

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

Signature

Regards,

Peo Sjoblom

Portland, Oregon

>I would use a help column, assume the times are truly numeric and not text
>
[quoted text clipped - 20 lines]
>>
>> Greg Hill

Reply to this Message

Gregg Hill - 09 Feb 2006 04:33 GMT

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

> Try this instead
>
[quoted text clipped - 26 lines]
>>>
>>> Greg Hill

Reply to this Message

Peo Sjoblom - 09 Feb 2006 14:59 GMT

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

Signature

Regards,

Peo Sjoblom

Portland, Oregon

> Peo, YOU
> RULE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
[quoted text clipped - 35 lines]
>>>>
>>>> Greg Hill

Reply to this Message

Gregg Hill - 09 Feb 2006 23:41 GMT

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

> 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
[quoted text clipped - 47 lines]
>>>>>
>>>>> Greg Hill

Reply to this Message

Peo Sjoblom - 10 Feb 2006 04:51 GMT

Thanks for the feedback

Signature

Regards,

Peo Sjoblom

Portland, Oregon

> Peo,
>
[quoted text clipped - 55 lines]
>>>>>>
>>>>>> Greg Hill

Reply to this Message