excel 2003 (11.8307.8221) SP3 - custom cell formatting question

[Bob]

Can someone point me in the right direction? I have an excel formatting
problem. The contents of the cells involved are calculated as follows:
cellA contents: "1/15/2010 4:00:00 PM" --- date format "3/14/2001"
cellB contents: "1/13/2010 7:00:00 PM" --- date format "3/14/2001"
cellC contents: "=sum(a1-a2)" --- time format "37:30:55"
--- result displays "45:00:00" which is what I'd expect:
exactly 45 hrs

But I can't figure out how to convert the cellC contents to display the
result in a "#days" format that shows elapsed time as "#days.tenths-of-days".
If I do the calculations manually, it should result in something like "45.0
hours = 1.875 days." I tried changing the cellC formula as follows, thinking
that would get me what I needed:
new cellC contents: "=sum((a1-a2)/24)"

if I use a time format for the cell - "37:30:55" - I get a display of
"1:52:30" ?????

if I use a custom format - "[h].0" - I get a display of "1.00" ?????

Can anyone advise how I can get display of "1.875" or "1.88"?

thanks!!!!

 

[Mike H]

Simply format as GENERAL
--
Mike

When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''s razor (Abbrev)

 

[Bob]

That did it - THANKS!!!!!!!

Simply format as GENERAL
--
Mike

When competing hypotheses are equal, adopt the hypothesis that introduces
the fewest assumptions while still sufficiently answering the question.
Occam''s razor (Abbrev)

Can someone point me in the right direction? I have an excel formatting
problem. The contents of the cells involved are calculated as follows:
cellA contents: "1/15/2010 4:00:00 PM" --- date format "3/14/2001"
cellB contents: "1/13/2010 7:00:00 PM" --- date format "3/14/2001"
cellC contents: "=sum(a1-a2)" --- time format "37:30:55"
--- result displays "45:00:00" which is what I'd expect:
exactly 45 hrs

But I can't figure out how to convert the cellC contents to display the
result in a "#days" format that shows elapsed time as "#days.tenths-of-days".
If I do the calculations manually, it should result in something like "45.0
hours = 1.875 days." I tried changing the cellC formula as follows, thinking
that would get me what I needed:
new cellC contents: "=sum((a1-a2)/24)"

if I use a time format for the cell - "37:30:55" - I get a display of
"1:52:30" ?????

if I use a custom format - "[h].0" - I get a display of "1.00" ?????

Can anyone advise how I can get display of "1.875" or "1.88"?

thanks!!!!