Use the IF function to create your own timesheet - Logical Functions - Microsoft Excel Tutorials

17.  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 fulfilled 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.

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->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=kAAoVojjaNc

  Hope You Like This Tutorial - Give Comments