Reputation: 1509
In Excel, a numeric value can be displayed as a date and time, and one possibility is to show the number of hours as an arbitrarily large number (not modulo 24), followed by minutes and seconds the normal way. For example: [h]:mm:ss
displays 956:45:32
for a value that corresponds to 956 hours, 45 minutes and 32 seconds.
I would like to have a similar format, but for days: [d] hh:mm:ss
, where I would like hh
to show hours modulo 24 as usual, but [d]
to show any number of days. This doesn't work, as it seems. I can use d hh:mm:ss
but that shows days modulo whole months, presumably starting with January. I.e. 32 days and 3 hours is displayed as 1 03:00:00
, while I would like to see 32 03:00:00
.
Is there a way to achieve this? I am not interested in VBA solutions, I just want a simple cell format.
Upvotes: 2
Views: 1577