Use the IF and time functions in Excel to calculate the commute status!

We all know that the current clock-punching system, production attendance of the staff need to your commute time, calculate the state of work, such as: Late, leave early, overtime, normal and so on. Here's a "helper" for you.

1. Open the Excel document. such as 2. Position the mouse in the cell F2 where you want to enter the function, then select "Formula" in the menu bar and select "Insert Function" in the common menu bar. Such as

3. Then pop the Insert Function dialog box, and then select the function to find the "IF" function, you can see the following specific description of its function, and then click "OK". Such as

4. At this point we set the function parameters (at this time in the IF function to apply "time" function), set to complete the click "OK", then calculate the C2 to work status. Such as

5. When the F2 results, the mouse moves to the lower right corner of the F2 cell to render black + character, double-click the left mouse button to automatically calculate the following data. Such as

6. Also enter the IF formula in G2, for example, normal off time is 6 o'clock in the afternoon, that is, 18 points. Specific as

7. Similarly, when the G2 results, the mouse moves to the lower right corner of the G2 cell to render black + character, double-click the left mouse button to automatically calculate the following data. Such as

Use the IF and time functions in Excel to calculate the commute status!