Forum Discussion
Product sum in a time reporting sheet.
- Sep 30, 2021
That is floating point error
Floating-point arithmetic may give inaccurate result in Excel - Office | Microsoft Docs
You may wrap you formula as =MAX(0, <current formula>)
NikolinoDE Thx for helping, but it wasn't exactly what I'm looking for.
Your formula only calculate the total amount of hours between the start and end time. That is already solved in Colum "H"
My problem is why z6 and z14 will go to a really small negative Time (excel cant handle that) when I replace the time 19:00 for 20:00 in G6 or G14.
The product sum is supposed to look for how many of the hours between 07:00 to 20:00 in this case that is labeled 100% on a Monday (måndag) according to the sheet "Datalistor (Rör ej)".
It should return zero or 00:00 but instead returns a fraction of a second (-5,6E-17)
That is floating point error
Floating-point arithmetic may give inaccurate result in Excel - Office | Microsoft Docs
You may wrap you formula as =MAX(0, <current formula>)