First & last date in range

I have a list of data attached which shows a sample of days taken sick by employees.

On some rows, the dates shows that the sickness lasted for 1 day only, but in some the sickness lasts for multiple days contigously. I need to generate a summary sheet that lists 1 row per employee per sickness bout, with a start date, end date & the number of hours taken off during that time. See example on summary tab which I've manually created based on a few rows from the orig data.

I started by using networkdays to highlight where the rows were that are an example of contigious sick days, but didn't get much further.

It doesn't have to be done through a formula, if it's a couple of manual steps/a pivot table etc. happy to do that instead. I just have about 100,000 rows of original data which I need to summarise in this way so looking for some help as to where to start.. Any ideas please?


Many thanks!

Amazing!! I've got absolutely no idea how that formula works but it seems to do the job perfectly. Thank you very much.