PPRuNe Forums - View Single Post - How to calculate h and min with Excel?
View Single Post
Old 29th Sep 2002, 18:35
  #1 (permalink)  
Squawk7777
 
Join Date: Aug 2000
Location: formally Alamo battleground, now the crocodile with palm trees!
Posts: 965
Likes: 0
Received 0 Likes on 0 Posts
Question How to calculate h and min with Excel?

I am trying to design my own logbook with Excel. Being a total inexperienced user of the so-called Master of Spreadsheet program, I find myself unable to pass the first "programming" hurdle.

It is fairly easy to make calculations with Excel, not when it comes to time units however. What settings/formulae must be used to do the following:

01:45
00:56
---------
Yes, I still know how to do this in my head, Excel however ....

7 7 7 7
Squawk7777 is offline