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!!!!

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" wrote:

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!!!!

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

"Mike H" wrote:

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" wrote:

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!!!!