calculating overtime idea

[lezawang]

Hi
I want to write a formula to calculate overtime. If the total hrs worked is more than 8 then that is overtime

I thought abut this formula but did not work. It only work if the difference is 1hrs and above. if it is 1/2hr then I get garbage number.

= max(A1-8,0)

total hrs worked	overtime
8	1.59872E-14
1	0
7	0
4	0
14	6

<tbody>
</tbody>

Any other formula will be ok as well. thank you so much.

 

[Dave Patton]

Excel 2010
	A	B	C	D
1	total hrs worked	overtime
2	8	0.00	format 2 decimal places
3	9.5	1.50
4	10.25	2.25
5	4	0.00
6	14	6.00
4a

Cell Formulas
Range	Formula
B2	= MAX(A2-8,0)
B3	= MAX(A3-8,0)
B4	= MAX(A4-8,0)
B5	= MAX(A5-8,0)
B6	= MAX(A6-8,0)

 

[Bo_Ry]

This is cause by floating point
https://www.microsoft.com/en-us/mic...y-does-excel-give-me-seemingly-wrong-answers/

Please use round
=MAX(ROUND(A2-8,2),0)