If formula to calculate worked hours

[sabrrrrina]

Hello!

I am trying to calculate my worked hours whilst accounting for my lunch break.
I have a 30 minute lunch break if I work more than 8 hours, but do not have a lunch break if I work 6 hours.
I want to incorporate this into my formula, so that it will calculate the hours worked and minus the lunch break if the value is over 8, but does not minus the lunch break if the value is 6.

I currently have this formula:

06:45​

15:30​

=IF(((E3-D3)*24)>8,- 0.5)​

This formula works but it inserts the value -0.50 instead of taking away 0.5 from the value after calculating E3-D3)*24 <-- that section of the formula.

In words I want: IF (15:30 minus 06:45) multiplied by 24 equals more than 8, then minus 0.5
And if the value is 6 then do not minus 0.5

I hope this makes sense...

 

[Peter_SSs]

Welcome to the MrExcel board!

Not entirely clear, but does this do what you want?

23 08 23.xlsm
	D	E	F
1
2
3	6:45	15:30	8:15
4	9:45	15:30	5:45
Hours

Cell Formulas
Range	Formula
F3:F4	F3	=E3-D3-IF(E3-D3>8/24,1/48,0)