Forum Discussion
Solved
Time calculation with decimal point issue
Good Day Team, I am working on an Excel sheet that has daily time tracking of employees, and final summarized monthly tracking. I have set all my decimals as 2 decimal points, and I specified in ...
Awfimohammed But that's not so strange. The first calculation (not rounded) results in 2.145833333 , thus, it becomes 2.15 rounded.
The other two calculations result in 0.29166666 and 1.85416666, which round to 0.29 and 1.85 respectively, adding up to 2.14
Perhaps you should use formulae like below to achieve what you need.
=ROUND(C6,2)-ROUND(B6,2)
Rounding on two decimal places means rounding on 0.01*24*60 = about 15 minutes. Not sure that could be corrected if only to calculate final value independently of intermediate ones.