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?
Thank you,
Juliana
Hi Juliana
Please attach what you have done so far for us to understand better your needs.
Sunny
Hi Juliana,
Do check these blog posts, I am pretty sure they will give you the guidance needed.
https://www.myonlinetraininghub.com/excel-time-calculation-tricks
https://www.myonlinetraininghub.com/calculating-time-in-excel
https://www.myonlinetraininghub.com/excel-networkdays-intl-function
Br,
Anders