0

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

Improve this question
1

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.

Improve this answer
0

Edited your file, this is the formula:

=INT(B2)*60*60+(B2-INT(B2))*24*60

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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