In Google Sheets, how do I math (value per hour) with durations over 24 hours?-CodePudding

I have durational times that run over 24 hours, but the hour() function returns as a reset (i.e. =hour(25:36:05) returns 1). I want to then sum said hour by another cell, specifically to find value per duration, times units.

See Image Example

CodePudding user response：

you can try like this:

=VALUE(S2)*T2

to get duration hours you can use:

=TEXT(S2; "[h]")

CodePudding user response：

HOUR() gets the hour of a day from date-time value which is stored as a number. So, HOUR() gives you modulo 24-hours sorta say.

Use instead this formula to get number of hours:

=INT(S2 * 24)