Forum Discussion
oolliivviiaa
Jan 26, 2022Copper Contributor
Calculating Employee Work Hours, Minus Lunch/Break Time
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: =(...
SergeiBaklan
Jan 26, 2022Diamond Contributor
oolliivviiaa
Jan 31, 2022Copper Contributor
Thanks for the reply.
I ended up creating a separate column for the lunch break. Then just subtracted the number from the work hours.