Forum Discussion
Solved
XL
Hi - I recently imported my Flight Logbook with 30 years of aeroplane flight data into an XL file. How do I calculate the total hours and minutes of flying totals when the flight goes through midnig...
BEN_FAWKES , in general rounding to nearest 5 min is as
=MROUND(A1,"0:05")
Assuming flights do not exceed 24hrs then
= MOD( EndTime - StartTime, 1 )
should do it. More generally you would need to use the date/time in which the integer part represents the date and the fractional part is the time.
Hi Peter
Thanks for your reply. I wrote the formula that you suggested but it simply calculated 00.00 when applied... any ideas?
Thanks for your reply. I wrote the formula that you suggested but it simply calculated 00.00 when applied... any ideas?