Forum Discussion

Cheryl2000's avatar
Cheryl2000
Copper Contributor
Nov 26, 2018

Excel Formula Help!

I am trying to figure out what formula to use when calculating an engines start and stop times.  The times are continual, as such over 24 hour periods.  What formula do I use for this example so I can calculate quickly how much time has elapsed:

010639:43:05010639:57:22
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Nov 26, 2018

    If they are in cells A1 and B1 when

    =LEFT(B1,6)/24+MID(B1,8,2)/24/60+RIGHT(B1,2)/24/60/60-(LEFT(A1,6)/24+MID(A1,8,2)/24/60+RIGHT(A1,2)/24/60/60)

    and format resulting cell as [hh]:mm:ss

Resources