How to use functions to make an attendance sheet in excel to show the status of late arrival, early departure and missed punching? Urgent! thank you

1. First, open the attendance sheet, click the cell where the status needs to be displayed, and enter the statistical command. "=IF(D6=", "not clocked in", IF(D6 & gt；; Time (8,0,0), "Late" and ")", where D6 stands for statistical time point and (8,0,0) stands for 8:00.

2. After the input is completed, click Enter, and you will see the statistical status displayed in the cell. Place the mouse in the lower right corner of the cell. When the mouse becomes a small cross, drag it with the mouse to complete the attendance statistics of a time point list.

3. After the completion of statistics, you can see the correct state, as shown in the figure below.

4, leave early statistics

First of all, open the attendance sheet, click on the cell that needs to display the status, and enter the statistical command, "=IF(E6=", "Not clocked in", IF(E6)

5. After the input is completed, click Enter, and you will see the statistical status displayed in the cell. Place the mouse in the lower right corner of the cell. When the mouse becomes a small cross, drag it with the mouse to complete the attendance statistics of a time point list.

6. After the completion of statistics, you can see the correct state, as shown in the figure below.