Get the Date time between two dates.

Question

I have two dates like '01-14-18 09:00:00 PM' and 01-15-18 08:30:00 AM

 

Now I want to get the table with columns like

 

DayName          StartTime            EndTime 

 Sunday             09:00:00             23.59.59

MonDay             00:00:00             08.30.00

 

 

Means I want a total time in each day.

 

Please, guys, help me.