Mark, see if this will help
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
"mark" wrote in message
oups.com...
I'm trying to do an employee timesheet.
I need to be able to enter a starting time / lunch in / lunch out / an
ending time. The fifth cell in that row needs to show the total hours
(minus lunch) with overtime in the sixth cell (hours over 10 hours).
Obviously I'm a novice with this program. Any help would be greatly
appreciated.
M