Yes, I see the problem now. I was reading the bit where you said "Result in
H18 = 16.9999999999999", but hadn't read that in conjuction with where you
showed that you were concatenating with a text string in that cell. Because
you're converting it into a text string the cell formatting isn't being
applied. You need
=TEXT(((F18-D18)*60)*24,"0")&" min."
--
David Biddulph

"Karen" wrote in message
...
Thank you for your response - When I click on the cell with the result
16.9999999999999, and then click on the "Decrease Decimal" icon, the
decimal
will not decrease. Then whild clicked in that same cell, I go to Format
Cells and the format is: Time 13:30. Also, when I format it to a number
with zero decimal places, it's still 16.9999999999999 - I thought that
maybe
it was cell F18 & D18 that was causing the problem, so I clicked in each
cell
and did Edit Clear All and re-entered the time. I'm still getting the
same result with 13 decimal places.
What else can I do? My boss is on my butt about this.
HELP!

"David Biddulph" wrote:

What do you mean by "Excel will not allow me to decrease the decimals
places"? What cell format do you have? What response do you get from
Excel
when you try to change the cell format? Can't you format it to number
with
zero decimal places?
--
David Biddulph

"Karen" wrote in message
...

I don't understand why I'm getting different results when I do a paste
special. When I paste the formula into certain cells, the result is
fine.
Then when I paste the formula into another cell, I'm getting a result
of
16.9999999999999 and Excel will not allow me to decrease the decimals
places.
Why is this happening and how can I get a result of 17 min.?

Cell F18 = 10:17 AM
Cell D18 = 10:00 AM
Cell H18 = The formula is: =(((F18-D18)*60)*24)&" min."
Result in H18 = 16.9999999999999

HELP!