Is there a kind of formula I can use for my schedule to add up the total amount of hours an employee is working. How it works is that it has monday-saturday and it says what time they start till the time the shift ends. I need to find out how many hours and employee is working for the entire week.

Look here: http://www.cpearson.com/excel/overt...

if you need additional assistance, or have further questions ask and we'll see how we can help.

Also, be advised there are a great number of Excel Work Schedule templates about,

these are from MS:

http://office.microsoft.com/en-us/t...MIKE

Ask Your Question

Weekly Poll