Calculating Time
I was having a few problems calculating the difference of time a few days ago
and I posted some questions and I received a lot of great help. Although,
I'm still having problems. I'm not sure if I reply to a message in that old
post, if anyone will see it. Not sure how that works. Therefore, I'm
posting a new message.
This is what I have:
I don't understand why I'm getting different results when I do a paste
special. When I paste the time 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!
|