Hi,

I too am stuck with a peculiar issue.

I have a sheet with seconds (from 0 to 10,000) against each person stating how much they used the phone on each day, I have converted the seconds to time by using <<=C2/86400>>, where c2 is the cell (column) for seconds. I wanted to display this as <<xx Days, xx Hours, xx Minutes, xx Seconds>>. So I tried using the custom formatting of the cell by putting <<dd "Days", hh "Hours", mm "Minutes", ss "Seconds";@>>. Worked fine till the usage goes over 30 days. If the person uses the phone for (lets say) 35 days, 2 hours and 31 minutes, it displays <<05 Days, 02 Hours, 31 Minutes, 00 Seconds>>. Is there any setting to get the absolute number of days stated as in <<35 days, 02 hours and 31 minutes, 00 Seconds>>?

Note: All workings have to dome in the same cell as the data is subjected to counts and sums using pivots.

Attached image should clear the requirements. Requesting Help.

Issue.jpg

Thanks.