1. First, record everyone's name and the corresponding punching time in Excel.

2. Then click the "Data" tab in the menu bar, and find the "Breakdown" in the "Data Tools" we need in the data tab.

3. Click "Separate" to open the tab, select "Fixed Width" and click "Next".

4. In the Text Sorting Wizard, adjust the position of the list appropriately so that each time point is separated, and then click Next.

5. The list will be separated separately.

6. according to the above steps, enter the function "= text (mod (C2-B2,1)," h hours and m minutes ") in the column of" Overtime "as shown in the figure, and then click Enter to display the D2 content.

7. When a cross cursor appears at the bottom of the display result bar, drop it down or double-click it to fill in all the contents.