cell format
 

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?

cell format
 

Hi,

Did you try

dd:hh:mm:ss

Mike

"pjr57" wrote:

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?

cell format
 

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?

cell format
 

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

"Mike H" wrote in message
...
Hi,

Did you try

dd:hh:mm:ss

Mike

"pjr57" wrote:

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?

cell format
 

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?