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!

Calculating Time
 

On Thu, 07 Dec 2006 16:36:02 -0000, Karen
wrote:

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!

Excel along with most PC programmes s not acurate to hundreds of decimal
places.
Floating point is notorously flacky.

You aren't subtracting 0 from 17, but 0.416666667 from 0.428472222
A result of 0.011805556, ie 17 minutes.
Though in my case this comes out as 17

In fact unless you have specified 13 decimal places I can't see how you
get your result

decide how accurate an answer you want.
If you want an answer to the nearest minute then just use the Round()
function



--
Steve (3)

Calculating Time
 

you are converting the number into text and running into a floating decimal
calculation issue if you want minutes only try
=round(((F18-D18)*60)*24,0)&" min."
you probably have something in I17 which keeps you from seeing the rest of
the text whihc would have the "min" portion
"Karen" wrote:

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!