PPRuNe Forums - View Single Post - How to calculate h and min with Excel?
Thread: How to calculate h and min with Excel?
View Single Post
Old 2nd February 2003 | 04:55
  #5 (permalink)  
Squawk7777
 
Joined: Aug 2000
Posts: 966
Likes: 0
From: formally Alamo battleground, now the crocodile with palm trees!
Thumbs up
Hamrah is correct!

It took me a while to restart this project . The key to correct calculations is to put the hours in brackets [hh]:mm. If you don't do it, Excel will not recognise it as elapsed hours, therefore you cannot exceed 24 hours.

7 7 7 7
Squawk7777 is offline