May 20 2019 07:52 AM
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 midnight?
i.e. through 24:00 hours...
May 20 2019 08:12 AM - edited May 20 2019 08:13 AM
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.
May 21 2019 01:02 AM
May 21 2019 01:08 AM
May 21 2019 01:21 PM
Solution@BEN_FAWKES , in general rounding to nearest 5 min is as
=MROUND(A1,"0:05")
May 21 2019 01:21 PM
Solution@BEN_FAWKES , in general rounding to nearest 5 min is as
=MROUND(A1,"0:05")