Formatting cells to show length of time in Days and hours

[Forum Freak]

Hi all

Is it possible to format cells to show length of time as "Days and Hours"?

I tried [d]:h (based on [h]:m) but this does not work. d:h gives a false
result if the value is a few months!

The majority of cells time value are around a couple of days but
occasionally some values are months or even over a year.

I do not want to format as "y:m:d:h" to cover every eventuality.

I am using excel2003

TIA

Kenny

 

[Tyro]

Have you read a book on how Excel keeps days and times. I'll be glad to
charge you $150. to answer your question. You can have the answer for the
price of a $4 0 book.

tyro

 

[David Biddulph]

You could do something like =INT(A2)&" days "&TEXT(A2,"hh")&" hours"

 

[Forum Freak]

Many thanks David - it worked a treat!

Kenny

You could do something like =INT(A2)&" days "&TEXT(A2,"hh")&" hours"
--
David Biddulph

Hi all

Is it possible to format cells to show length of time as "Days and
Hours"?

I tried [d]:h (based on [h]:m) but this does not work. d:h gives a false
result if the value is a few months!

The majority of cells time value are around a couple of days but
occasionally some values are months or even over a year.

I do not want to format as "y:m:d:h" to cover every eventuality.

I am using excel2003

TIA

Kenny