PPRuNe Forums - View Single Post - Adding Time
Thread: Adding Time
View Single Post
Old 29th July 2004 | 22:19
  #7 (permalink)  
Fly Stimulator
Carbonfibre-based lifeform
 
Joined: Mar 2002
Posts: 747
Likes: 0
From: London
If you are using MS Excel, use two separate columns for hours and minutes, and a bit of judicious arithmetic in the totals column - easily done.
Or one column with times entered with hours and minutes separated by a colon eg. 1:30, 0:50, 2:25 etc.

In order to make sure it deals with totals exceeding 24 hours you need to set the cell format to [hh]:mm using Format Cells/Custom.





Or try this Excel spreadsheet.

Right-click on that link and save it to your machine. It adds up your hours, keeps track of what you\'ve done in the last 90 days etc.

Last edited by Fly Stimulator; 29th July 2004 at 22:36.
Fly Stimulator is offline