Microsoft Office Tutorials and References
In Depth Information
Figure 6-9: An employee time sheet workbook.
This worksheet assumes that hours that exceed 40 hours in a week are considered overtime hours. The work-
sheet contains a cell named Overtime (cell C23) that contains 40:00. If your standard workweek consists of
something other than 40 hours, you can change the Overtime cell.
The following formula (in cell E18) calculates regular (non-overtime) hours. This formula returns the smaller of
two values: the total hours, or the overtime hours.
The final formula, in cell E19, simply subtracts the regular hours from the total hours to yield the overtime