Timesheet Calculation Formatting|General Excel Questions & Answers|Excel Forum|My Online Training Hub

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