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.