September 28, 2018
I need to create new timesheets and am running into a wall when trying to figure out a formula.
What needs to be tracked is time worked (as decimal) and meal break (as decimal) where staff enters:
The cells staff fill in are: Time in - Time out (meal) - Time in (meal) - Time out --
The cells that populate are: Hours worked -- Meal break
I am able to get this done using this formula for hours worked: =SUM(IF(C5<B5,C5+1,C5)-B5,IF(E5<D5,E5+1,E5)-D5)*24
And this formula for meal break: =MOD(D5-C5,1)*24
What I can't figure out is what to do if people come in and leave and DON'T take a meal break. Can anyone help?
June 25, 2016
December 7, 2016
Do check these blog posts, I am pretty sure they will give you the guidance needed.