Re: 24 hour time in excel

2006-01-14 Thread Chris Burton
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

24 hour time in excel

2006-01-13 Thread Chris Burton
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

Re: 24 hour time in excel

2006-01-13 Thread James Devenish
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

Re: 24 hour time in excel

2006-01-13 Thread Warren Jones
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