Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting a weekly time sheet
I'm a newbie using excel 2003, and trying to format a weekly time sheet that
totals the hours worked for several different activities. I would like to format two more cells labeled "regular hours" and "overtime hours" so that the total of hours worked up to and including 40 hours appears in one, and the total of hours worked over 40 appears in the other. For example, J30 has the formula =SUM(J4:J29). When that total exceeds 40, how do I format D32 to include the hours up to and including 40, and format D34 to include everything over 40? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting a weekly time sheet
The following formulas will give you regular hours and overtime hours given a total number of hours in cell A1. =MIN(A1,40) will return the regular hours, up to a maximum of 40. =MAX(0,A1-40) will return the overtime hours. If A1<40, it returns 0. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Mon, 8 Dec 2008 13:10:01 -0800, Sparky wrote: I'm a newbie using excel 2003, and trying to format a weekly time sheet that totals the hours worked for several different activities. I would like to format two more cells labeled "regular hours" and "overtime hours" so that the total of hours worked up to and including 40 hours appears in one, and the total of hours worked over 40 appears in the other. For example, J30 has the formula =SUM(J4:J29). When that total exceeds 40, how do I format D32 to include the hours up to and including 40, and format D34 to include everything over 40? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting a weekly time sheet
See Chip Pearson's site for setup and formulas for timesheets and overtime.
http://www.cpearson.com/excel/overtime.htm Gord Dibben MS Excel MVP On Mon, 8 Dec 2008 13:10:01 -0800, Sparky wrote: I'm a newbie using excel 2003, and trying to format a weekly time sheet that totals the hours worked for several different activities. I would like to format two more cells labeled "regular hours" and "overtime hours" so that the total of hours worked up to and including 40 hours appears in one, and the total of hours worked over 40 appears in the other. For example, J30 has the formula =SUM(J4:J29). When that total exceeds 40, how do I format D32 to include the hours up to and including 40, and format D34 to include everything over 40? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weekly time sheet for the whole team?(6 members) | Excel Worksheet Functions | |||
Creating Bi-Weekly Time Sheet to Calculate Hours Worked | Excel Discussion (Misc queries) | |||
Excel Bi-weekly time sheet change dates to Thursday- Wednesday? | New Users to Excel | |||
How to set up weekly time sheet with flexi time. | Excel Worksheet Functions | |||
I need an Excel bi-weekly employee time sheet template | Excel Discussion (Misc queries) |