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...

excel

Formulas and Functions

SergeiBaklan
Mar 22, 2019
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")

SergeiBaklan

Diamond Contributor

Mar 22, 2019

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
Copper Contributor
Mar 26, 2019
Thank you very much it solves that problem!
- SergeiBaklan
  Diamond Contributor
  Mar 26, 2019
  Goldridge , you are welcome

Forum Discussion

Excel 2013 Date computation bug

Resources