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)

[TABLE="class: grid, width: 199"]
<tbody>[TR]
[TD]total hrs worked[/TD]
[TD]overtime[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]1.59872E-14[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]6[/TD]
[/TR]
</tbody>[/TABLE]

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)