Home |
Search |
Today's Posts |
#1
|
|||
|
|||
question about a basic formula
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Chip Pearson has a bunch of information on time calculations and has a
downloadable spreadsheet that does just what you need. http://www.cpearson.com/excel/overtime.htm ************ Anne Troy www.OfficeArticles.com "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 |
#4
|
|||
|
|||
perfect!
thanks very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Very simple, but difficult formula question | Excel Worksheet Functions | |||
formula question | Excel Worksheet Functions | |||
basic pie chart question | Charts and Charting in Excel |