USE THE IF FUNCTION TO CREATE YOUR OWN TIMESHEET USING MICROSOFT EXCEL

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:

USE THE IF FUNCTION TO CREATE YOUR OWN TIMESHEET USING MICROSOFT EXCEL

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

USE THE IF FUNCTION TO CREATE YOUR OWN TIMESHEET USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Logical Functions in Excel, IF Function in Excel, Use the IF function to create your own timesheet using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel