Thanks, Fred. I appreciate the help.
John


"Fred Smith" wrote:

Unfortunately, Excel does not support a format of [dd] the way it does [hh].
You will need to split the cell.

=int(celladdress) will give you just the days -- format it as general.
Format the other cell as hh:mm

Regards,
Fred.

"John MacAllister" wrote in
message ...
OssieMac,
Very helpful, thanks. Now, if I wanted to display the number of days, how
would you advise?
Thanks.
John


"OssieMac" wrote:

Format the cell as [h]:mm.

The square brackets around the h tell it to display the hours instead of
thinking it is the next day.

Go into number format-time-custom and enter the format as above.

--
Regards,

OssieMac


"John MacAllister" wrote:

Hello. I have a simple spreadsheet that tracks my running. I enter
the
miles run and elapsed time in two columns. The format in the time
column is
hh:mm:ss. Two more columns track cumulative distance and cumulative
time.
The format used in the cumulative time cell is d hh:mm. Once the total
cumulative time reaches 31 23:59, the next cell returns:
1 hh:mm instead of 32 hh:mm. Am I doing something wrong? Many thanks.
John