cell format

[pjr57]

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?

 

[Mike H]

Hi,

Did you try

dd:hh:mm:ss

Mike

 

[Bob Phillips]

Use a custom format (Format>Cells>Custom) of 'd "days" h:mm' without the
single quotes.