Forum Discussion
Solved
Excel 2013 Date computation bug
Hi, I can't figure out what's the problem in this situation: When I calculate the sum of the time spent of the day, with those values: (see attachement) Start End Start End Total Fo...
Goldridge , that is floating point calculation issue. In Excel one minute is 1/24/60, you calculate them as floating point numbers. To fix you may round the time to nearest second
=MROUND(F2-G2,"0:00:01")
Goldridge,
It would appear that when calculating time excel falls over sometimes in rounding, in this case around the 14th decimal place, as you can see from the attached example. I changed the time serial number to a number format so you can the decimal places and used a Round function for both the time calculation and the time validation value.
I think it is just one of quirks of excel.
Thank you too for the details analysis!