Jul 08 2021 06:55 AM
Jul 08 2021 07:38 AM
SolutionIt is a rounding error caused by the way dates and times are represented in binary notation. To get rid of the discrepancy, use the ROUND function. In E3:
=ROUND((C3-D2)*1440,0)
Fill down.
Jul 08 2021 07:39 AM
Jul 08 2021 07:38 AM
SolutionIt is a rounding error caused by the way dates and times are represented in binary notation. To get rid of the discrepancy, use the ROUND function. In E3:
=ROUND((C3-D2)*1440,0)
Fill down.