Forum Discussion

BEN_FAWKES's avatar
BEN_FAWKES
Copper Contributor
May 20, 2019
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...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    May 21, 2019

    BEN_FAWKES , in general rounding to nearest 5 min is as

    =MROUND(A1,"0:05")
Twifoo's avatar
Twifoo
Silver Contributor
May 21, 2019
Try this:
=(EndTime+(EndTime<StartTime)-StartTime)*24
BEN_FAWKES's avatar
BEN_FAWKES
Copper Contributor
May 21, 2019

Twifoo 

 

Thanks.  Peters formula works - 99.9% of my hours are rounded to the nearest 5 mins but there is a cell that isn't somewhere in the totals column - how do I spot it/them to round them please? Already tried the search function for 8 in a highlighted column...

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 21, 2019

    BEN_FAWKES , in general rounding to nearest 5 min is as

    =MROUND(A1,"0:05")

Resources