|
|
| Re: Excel (1457922) | |||
 |
|||
| Home > SubChat | |||
|
[ Read Responses | Post a New Response | Return to the Index ] |
|
||
|
Re: Excel |
|
|
Posted by Bill West on Mon Dec 11 15:31:05 2017, in response to Re: Excel, posted by BusRider on Mon Dec 11 11:28:38 2017. Yes, the division of a number of minutes could leave a small fraction of a minute. If that is to always be rounded up then CEILING(number of minutes,"0:01") will do the trick.This is a general point in spreadsheet design, while the display is rounded the underlying number is always carried to 30 odd decimal places. When you are doing accounting or in this case timekeeping you have to watch for any calculation that could produce a fraction and round it back out in the same direction a person would, so that it doesn't carry any farther. Because some calculations prepare a first result (ST) and then derive a second (OT) from the difference between the first and the input you have to decide which calculation should be done and rounded first because that determines who is going to gain from the rounding and who is going to lose. If the company does it in the opposite order your results won't match. Bill |
|
|
|