Hi Alicia,

See John Walkenbach's Employee Time Sheet workbook which is freely
downloadable at:

http://www.j-walk.com/ss/excel/files/timesht.htm


---
Regards,
Norman



"Alicia" wrote in message
...
I am trying to develop an excel spreadsheet that will show the scheduled
hours worked as well as allow me to tabulate the total number of hours for
each worker as well as total hours per day. I attempted to use ="7 AM" -
"5
PM" function, but it was unable to handle the data in that order. I would
prefer to be able to post the schedule so others can see it as well as
have
it auto tabulate the hours.

Thank you for your help.

Alicia