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