Actually, at this point I can get the longer method to work but not the
shorter. When I say "doesn't work" I mean the resulting box shows
"0:00". I did this by opening a new spreadsheet, entering the values as
such:

a b c d e
1 13:00 13:40 =B1-A1 22 =D1/(24*C1)

That does not work. I wind up with 0:00 in e1. But when I use the
longer version you sent (= D1/(C1/TIME(1,0,0))), it works just fine. I
just need to figure out why it's not working in my original sheet, so
you've still given me a solution.

Thanks!,
Jason

JE McGimpsey wrote in
:

Both methods work for me. What does "doesn't work" mean to you? Do you
get the wrong value? An error? a crash?

Did you format the cell as General or another number format?

Are your times In article
,
Nascent wrote:

Thanks for the reply but it doesn't work. I've even made sure there
was no formatting that was munging up what I was seeing. I tried
both methods, too.