Home · Maps · About
Home > SubChat
 

[ Read Responses | Post a New Response | Return to the Index ]
[ First in Thread ]

 

view flat

Re: Excel

Posted by Bill West on Sat Dec 16 15:13:44 2017, in response to Re: Excel, posted by BusRider on Sat Dec 16 12:20:53 2017.

When you use a CEILING function any tiny carryover in the previous calculations will get rounded up, even if it is too small to display. IE if the previous answer is 2:36.0000001, CEILING will change it to 2:37. Use the Formulas/Evaluate Formula/Evaluate commands to see what is being used at each calculation step.

You can also format the cell as a decimal to 10-15 places and widen the column width to see that. Compare it with what you think the time should be in 24hr decimal format.

2:36 AM is 0.108333333333333 and running =CEILING(A1,"0:01") gave me 2:36. The number 0.108333333333334 however gave me 2:37

Bill

(There are no responses to this message.)

Post a New Response

Your Handle:

Your Password:

E-Mail Address:

Subject:

Message:



Before posting.. think twice!


[ Return to the Message Index ]