Creating new rows based on Criteria and populating them

[korallis]

I have a sheet that runs a macro to populate all data,

however I have another tab I need populating based on the results of the LeeMerge tab.

Date S Day Start Date E End WORKING HOURS Night Day Sat Sun
Peace Igodifo 03/09/2018 Mon 19:30 04/09/2018 08:00 11.50 9.00 2.50 0.00 0.00


This is on one tab
I need tab Completed to populate so the hours are on each line.

for example

Peace Igodifo 03/09/2018 Mon Night 9.00
Peace Igodifo 03/09/2018 Mon Day 2.50

Thats what the above example would produce.

I have included an updated example sheet that includes the leemerge tab and the completed tab showing expected output.

I appreciate everyones help