Staff clock data conversion into time table per staff member

Hi,

A friend recently purchased a new fingerprint clock for his staff to record their working time. The staff start early, have a break round about 09h00 for approximately 30 min and then work until lunch. Take 1h30 lunch break, and then work until the end of the day.

The data downloaded from the clock is in the sheet "Raw Data". The format I would like to convert the data to is shown in sheet AttendRecord - the data in the "RawData" sheet was not used to compile the table in AttendRecord, it is just to indicate the required format of the converted data.

Can someone please assist. It can be done manually, but it will take a considerable amount of time.

Please assist with a formula to convert the raw data into the table format data for each staff member.

Kind regards,