How to make overtime schedule with excel

1. Many attendance systems record daily attendance as shown in the figure below. As you can see, all the attendance records of that day are in one cell, so it is impossible to make effective statistics. Therefore, it is necessary to separate these attendance records and remove non-overtime records in order to make overtime hours statistics.

2. Select all the punch records, as shown in the figure below, and open the data column menu in turn.

3. Then, select the appropriate file type in the text sorting wizard. Generally, records are separated by separators such as spaces, so you need to select "separator". Then click Next to proceed to the next step.

4. Then, choose the separator according to the recorded data, for example, spaces are used in the data demonstrated in this article.

5. Then, select the data format of each column after column separation, and generally select "General". At this point, the column setting is complete, just click the "Finish" button.