Calculating Employee Work Hours, Minus Lunch/Break Time

[oolliivviiaa]

Hi All, 

I need help creating a formula and what cell to put the formula in. (See my image of sheet below)

This is the formula I am using for the days of the week to calculate work hours:  =(ABS(B3-B4 )* 24)

I've tried =IF formula and it almost worked but ended up not being sufficient. 

If I need to redo the layout of the current sheet, I can.  Thanks for any advice and solutions!

[#2]

@oolliivviiaa 

Here

it could be like

=MOD(B4-B3,1)*24 -(J3="x")*0.5-(O3="x")*0.75

[#3]

Thanks for the reply. 

I ended up creating a separate column for the lunch break. Then just subtracted the number from the work hours. 

@Sergei Baklan