Kc, have a look here

http://www.cpearson.com/excel/overtime.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kc sunshine" <kc wrote in message
...
I am establishing a Timesheet for our business in Excel. I have cells for
"In" , "Lunch Out", "Lunch In" and "Out" that employees will enter their
times (in military time). Need the formula that will calculate the total
hours for the day, subtracting out for the lunch break.

Thanks!