Hi Chris
All times are stored as fractions of a day.
So you need to do as James suggested (if you have hours separately
stored) or do something like
Assuming you have orig time in Col A, time + 8:00 in Col B, make a
col C with the following formula...
=IF(B1>=1,B1-1,B1)
(to subtract 1 day off when the clock ticks over
Or you could combine with your timezone correction calcs
woz
On 13/01/2006, at 6:24 PM, Chris Burton wrote:
Hi waymuggers
I have a time calculation problem I've being trying to resolve for
the past 4 hours, and my brain now hurts a lot!.
I have two excel files filled with 9000 records from a gps in which
the time was set to be 8 hours behind. If I add 8 hrs to those
records with the time after midnight (eg 0:00:25) for example,
starts the day at 8:00:25. But the records with time prior to
midnight (eg 22:15:25 ends up at 30:15:25). For the life of me I
cant figure it out, even after doing some googling. Can someone
with good brain cells please help me?
kindest regards
chris
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Warren Jones http://
homepage.mac.com/warrenj/
Perth, Western Australia
