Calculating Employee Work Hours, Minus Lunch/Break Time

Question

Hi All,&nbsp;&nbsp;I need help creating a formula and what cell to put the formula in. (See my image of sheet below)&nbsp;This is the formula I am using for the days of the week to calculate work hours:&nbsp; =(ABS(B3-B4 )* 24)&nbsp;I've tried =IF formula and it almost worked but ended up not being sufficient.&nbsp;&nbsp;If I need to redo the layout of the current sheet, I can.&nbsp; Thanks for any advice and solutions!&nbsp;

sergeibaklan · Answer

oolliivviiaa&nbsp;
Here

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

oolliivviiaa · Answer

Thanks for the reply.&nbsp;&nbsp;I ended up creating a separate column for the lunch break. Then just subtracted the number from the work hours.&nbsp;&nbsp;SergeiBaklan&nbsp;

Forum Discussion

Calculating Employee Work Hours, Minus Lunch/Break Time

2 Replies

Resources