4 years ago
Forum
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
4 years ago
=TEXT(B2-A2, "h:mm")