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.

=MIN(E17,Overtime)

The final formula, in cell E19, simply subtracts the regular hours from the total hours to yield the overtime

hours: