M
Matt
I got help with this formula earlier and it is working in all cells but one.
The formula is as follows:
first employee
hours worked 42 (first cell set with formula
=MIN(SUM(B6:C6
6:E6:F6:G6:H6),40)
over time cell to show the 2 hours worked overtime formula set as
=MAX(0,SUM(B6:H6)-40) (IT WORKS GREAT)
But, I have the second employee set with the same formula
=MIN(SUM(B12+C12+D12+E12+F12+G12+H12),40) but using the same formula to have
the overtime hours to move over into the second cell changing the formate to
read =MAX(0,SUM(B12+C12+D12+E12+F12+G12+H12)-40) it gives me this error in
the cell 1.42109E-14.
Can someone help figure out what is happening to get this error and how to
correct it??
The formula is as follows:
first employee
hours worked 42 (first cell set with formula
=MIN(SUM(B6:C6
6:E6:F6:G6:H6),40)over time cell to show the 2 hours worked overtime formula set as
=MAX(0,SUM(B6:H6)-40) (IT WORKS GREAT)
But, I have the second employee set with the same formula
=MIN(SUM(B12+C12+D12+E12+F12+G12+H12),40) but using the same formula to have
the overtime hours to move over into the second cell changing the formate to
read =MAX(0,SUM(B12+C12+D12+E12+F12+G12+H12)-40) it gives me this error in
the cell 1.42109E-14.
Can someone help figure out what is happening to get this error and how to
correct it??