Time Sheet in Excel - Formulas with Breaks

L

lilmud33

I have created an Excel spreadsheet to calculate an employees time shee
automatically.

The problem I am having is that there are three required break
formulated into the day one of them being lunch. The other two ar
just 10 minute breaks around the 10am and 3pm times.

However, if the employee does not take the break then entering a das
or 0 in the cell makes my formula not calculate properly.

Does anyone have a template they could e-mail me that is already se
up? I need help!

Thanks!

J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top