SUMIF Alternative to reduce processing time

I have a functioning spreadsheet, which uses multiple SUMIFS to organise a table of data from multiple lines per employee into single lines per employee. The issue is, there are many rows and it requires around 250000 SUMIFS to work, which obviously means it takes a huge amount of time to process. I'm wondering if anyone else can suggest a better solution which could reduce this. I'm happy to use VBA, but my skills with it are quite limited.

The data shows employee information, shift start/end times and durations. Because of the way it's exported, these are on multiple lines, and I need to show them on one line only. For each employee, the only variation between the rows are the shift times.

The attached sheet shows the data I start with (the top table) and how I need it to be (the bottom table). For each employee, there will only ever be one shift per day (so there isn't the possibility of two lines for one employee to both show duplicate or different shifts.

Thanks in advance for your help.

Hi,

The sheet that I posted was actually a mock up of the results I need. The actual data will need to be across two sheets. The first one is essentially the top table, and the second sheet is where I need the data sorted into one line to go. They are identical in layout.

Thanks for your help.