Formatting more than a months worth of seconds

[schishol]

First, let me clarify that I am NOT trying to "convert" seconds to a "# of days, #of hrs, # of mins" ... I am trying to take a cell that has a number of seconds already in it, but I would like it "displayed (formatted) to show "# of days, #of hrs, # of mins".

I'm struggling with finding a custom format that would do this. Anybody know of any solutions? Placing [] around h, m, or s will make them cumulative, but I'm not aware of a "day" equivalent.

Example: 5093600 ... It would be ideal if I could have it displayed as 58 days, 22 hrs, 53 min.

 

[MUKESHY12390]

If you need all details at same time in terms of #of day , #of hrs , #of minutes, Then I doubt that you will get that just doing formatting.

 

[shg]

For days exceeding 31, formatting won't work. You would need a formula, and the result would be text.

 

[schishol]

For days exceeding 31, formatting won't work. You would need a formula, and the result would be text.

I believe you are correct, but I thought I would throw it out there in case there is a hidden "just do it" excel button I haven't found yet.

 

[shg]

No hidden button that I'm aware of.