We are in between scheduling software and need to use Excel during the down
time for our scheduling
I would like to come up with a formula that will do the following (if
possible) - schedule breaks and lunches with set guidelines
I.E 2 hours after start, etc
Show me where I have staffing (exlcuding when someone is on a break/lunch)
Calculate hours work for the day/week

Name Start Break Lunch Break End total worked
John 09:00 11:00 13:00 15:00 17:30 8.00
Jane 07:00 09:00 11:00 13:00 04:30 8.00

I know there are a lot of knowledgable folks our there, so I'm hoping
someone can lend a hand!

Thanks in advace