PPRuNe Forums - View Single Post - excelpilotlogbook.com
Thread: excelpilotlogbook.com
View Single Post
Old 24th January 2014 | 16:33
  #7 (permalink)  
Tone
20 Anniversary
 
Joined: Mar 2004
Posts: 186
Likes: 0
From: Midlands
For info; in Excel if you need to sum columns of hours & mins format the individual cells as hh:mm. Then format the total cell as [h]:mm. This forces it to sum in hours instead of its horrible trick of subtracting 24 hours for every day it sees.
Tone is offline  
Reply
0