There's a sample file here that will give you some ideas including formulas:
http://j-walk.com/ss/excel/files/timesht.htm
Biff
"myropro3" wrote in message
...
I am trying to set up a schedule in excel for my 6 employees to track time
what are the formulas that i would use to track time excluding a 30 minute
lunch brake?