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
=(DAY(F5) * 24) + HOUR(F5) but that failed, since that function gives the date of month.
I’m all out of ideas now.