How to extract >24 hour value from custom time format?

[Atli]

I’m trying to get the HOUR() component from a custom time format in Calc, that counts hours past the 24 hour mark: [H]"h "M"m", but I’m not having much luck. The values I’m using look like: 75h 10m, from which I’m expecting =HOUR(F5) to return 75, when in fact it returns 3. So in fact it seems to be dividing the real value by 24 and giving me the remainder.

Is there another way to get this component? Another function, perhaps?
I’ve tried looking over the function list and didn’t see anything that seemed useful. Tried combining this with the DATE function: =(DAY(F5) * 24) + HOUR(F5) but that failed, since that function gives the date of month.

I’m all out of ideas now.

[AlexanderShagin]

=DATEDIF(“00:00:00”;F5;“d”)*24+HOUR(F5)

[Lupp]

An alternative: =INT(F5*24)

Or (hinting the fact of working with date-time values): =INT(F5)*24+HOUR(F5)

[Lupp]

An alternative: =INT(F5*24)

Or (hinting the fact of working with date-time values): =INT(F5)*24+HOUR(F5)