I need to copy, split and transpose the times on a roster to the times on a
timehseet.

Sheet1 is a roster.
Sheet2 is a timesheet.
Sheet2 has to get its information from sheet1.
The times are shown in the sheet1 range: B2:B8 as "9:00 - 5:30pm".
The times must be entered into the sheet2 range:
C8 as 9:00
D8 as 17:30
C9 as 9:00
D8 as 17:30
etc down to D14.