Hello…

I have problem formatting time.

If (numeric) cell have value of 120 (120 days) then:

[HH]:MM give me 2880:00 (correct response)

[DD]:HH:MM 29:00:00 (wrong respponse)

I wish to get result like days:hours, but days can be more than 31!

is that possible at all with simple cell formatting?

The cell itself have pretty long formula so using / and MOD and joining result is not deserved option.

Thanks