How does Excel make a company employee's work schedule?

1. There is an employee attendance sheet, as shown in the figure. Everyone's punching time is different, and the rest time may be different.

2. Double-click the cell in the Working Time column and enter ==D2-B2-C2. Working hours are off-duty hours minus working hours minus lunch breaks.

3. It is calculated that the working time of the current employee is 8:00, that is, 8 hours, but this display effect is not intuitive.

4. Here we can use the text function to format the display duration.

5. Modify the formula of the duration cell: = text (d2-b2-c2, "m minutes is h").

6. Drag to automatically fill other cells and automatically calculate the working time.