Thanks, but that still is not working.
Let me be clear
in column A I have a time 12:00:00 AM expressed in GMT
I want a forumulae or function to convert this to read 16:00:00 pm PST
Thanks
"George Nicholson" wrote:
Date/time values in excel are based on 1 = 1 day, so 1 hour = 1/24. 8 hours
= 8/24 (or 0.3333...)
HTH,
--
George Nicholson
Remove 'Junk' from return address.
"PivotMan" wrote in message
...
Hello, I am looking for a way to convert time in excel. I have a colume
of
data represeting time in GMT and I want to covnert it to Pacific
time...not
an incredibly complex calculation, but I in trying to substract 8 hours
from
GMT, I am getting errors.
Any thoughts? Thanks
|