I want to convert from duration ( HH-MM-SS) to minutes, but the result return only correct when duration of hour < 24 hour with function HOUR(). Otherwise result is not correct.

Anyone can help?

below is link : https://docs.google.com/spreadsheets/d/1w4DksMyaJbJQd3Sp3fsBPACTc1u14SOXObZUKXC1j38/edit?usp=sharing

2 Answers 2


By one side, durations as well as dates are handled by Google Sheets as serialized numbers, by the other side, HOUR treats it's argument as a date.

The unit for dates, including durations, is 1 day. To get the hours divide the duration by 24.


Edited your file, this is the formula:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.