Excel Formula minutes convert to hours

Why not format the cells to a time format thus-
Format - cells - time - 37:30:55

This will give time in hours minutes and seconds that can be added

Sorry excell dont work like that. If you try to enter say 1hr 30min as 1.5
it trys to use it as a date function and displays 12:00:00 and if you try to
add times it treats them also as dates such that 12:00:00 + 12:00:00 =
0:00:00.

I use two columns and add one mod 60 etc.

Peter.



Excell does work like that! ie for a flight of 8hrs 57min you put 8:57
You have to use the format including seconds at the one for just hrs:min will
give you a false reading at higher values.
I have entered my logbook for over 600 flights using this method and it works
for me.