Microsoft Excel Functions & Formulas

Use the IF function to create your own

timesheet

In the last example for this chapter we create our own timesheet,

step by step. First, press <Shift+F11> to insert a new worksheet.

Then create the following timesheet as an example:

We have to consider that the daily target of eight hours is still ful-

filled when an employee is ill (IL), on holiday (HO), or in training

(TR). For other days, the number of working hours has to be

calculated.

4

To calculate the daily working hours:

1. Select cell F2:F6 and type the following formula:

=IF(OR(C2="TR",C2="IL",C2="HO"),E2,D2-C2).

2. Press <Ctrl+Enter>.

56

Chapter 2

Figure 2-17

Figure 2-18