PPRuNe Forums - View Single Post - How to calculate h and min with Excel?
View Single Post
Old 21st February 2003 | 13:44
  #9 (permalink)  
Kolibear
 
Joined: Jan 2003
Posts: 1,082
Likes: 0
From: SX in SX in UK
If you format the cells using the following :- Format - Cells - Time then pick the example '30.55.7' this will quite happily add up you hours past 100hr - at least it does on my electro-logbook.

BUT!! if you have Windows XP, this particular format has been removed and the time will only total up to 23:59
Kolibear is offline