ms excel
Thread Starter
Join Date: Aug 2000
Location: cambridge uk
Posts: 288
Likes: 0
Received 0 Likes
on
0 Posts
ms excel
i am trying to create a simple log book to calculate my monthly and total time but i am having problems. For some reason the totals are complete garbage for each month and i just add them up normally, can anyone help? i have done many searchs' and have downloaded some templates but nothing is what i really want.
Thread Starter
Join Date: Aug 2000
Location: cambridge uk
Posts: 288
Likes: 0
Received 0 Likes
on
0 Posts
actual times, as i understand excel as soon as it gets to 24 hours total it then decimalises. This is where it seems to go wrong, for instance i have a long list of flight times which add up in excess of 24 hours per month and i get a total at the end which is not correct.
Have a look in http://www.pprune.org/forums/showthread.php?t=158700
for some tips on working with times in Excel (the thread is about rounding them, but there might be something in there for you).
for some tips on working with times in Excel (the thread is about rounding them, but there might be something in there for you).
Join Date: Apr 2002
Location: lots of different places....
Posts: 117
Likes: 0
Received 0 Likes
on
0 Posts
I used to have the same problem, but in the more recent versions of Excel under format cells option there is a time option of either 30:55.2 or 37:30:55, both of these get around the resetting the number when you go past 24 hours.
Thread Starter
Join Date: Aug 2000
Location: cambridge uk
Posts: 288
Likes: 0
Received 0 Likes
on
0 Posts
got a mate to help me, not sure what he did but it adds up correctly and decinalises the minutes but thats no problem its only to make sure i have done it correctly in th e first place . thanks everyone