Forum Discussion
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 ca...
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
