cell format

P

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?
 
B

Bob Phillips

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