Forum

How to do calculations around Hours & Minutes?  

  RSS

0

I need to calculate diesel consumption per hour.
I have diesel generator running time in hours, minutes (HH:MM) and Fuels consumption in Liters.

Can anyone tell me what will be the formula (considering minutes as well, as lets say 25 minutes i convert in numbers it will come 41.667 so how can i add that in my hours say 25 hours 25 minutes is total running time of Diesel Generator.)

 
0

=TEXT(B2-A2, "h:mm")

 
Share:
 
  
Working

Please Login or Register