Hi Woz and James
Thanks very much for you suggestion, it worked very nicely. I was
trying to do it in two steps and had the +8 worked out. I did have
columns A and B set up but didnt understand how excel would work with
times.
A really top program when you know how it works!
Thanks once again for you help with this guys
kindest regards
chris
On 13/01/2006, at 7:05 PM, Warren Jones wrote:
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
-- The WA Macintosh User Group Mailing List --
Archives - <http://www.wamug.org.au/mailinglist/archives.shtml>
Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml>
Unsubscribe - <mailto:[EMAIL PROTECTED]>
WAMUG is powered by Stalker CommuniGatePro