OK until it goes beyond 31 days.
--
David Biddulph

"Bob Phillips" wrote in message
...
Use a custom format (FormatCellsCustom) of 'd "days" h:mm' without the
single quotes.

--
__________________________________
HTH

Bob

"pjr57" wrote in message
...
How do I change a cell whose content is hh:mm:ss and the value might be
267:45:00 to a format that displays the days:hours:minutes?
Is this possibe?