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
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
Hi Chris,
On 13/01/06, Chris Burton [EMAIL PROTECTED] wrote:
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).
I am not familiar with how Excel
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
4 matches
Mail list logo