Auto Calculate When Applying Time Slicers

Hi guys,

I have the following data table and shows a sample entry below. I have attached a sample pbix file (click here: file):

1. I want to add columns wherein it would compute for the following via new columns "Hours", " Minutes", and "Seconds".
Note: Exclude Sundays in calculation

2. Add a slicer wherein "yyyy/mm" and it will get data from start of that month until the end of that month only.
Note:
- "yyyy/mm" basis here is the "StatusDateEnd" column. 
- It will exclude any data before or after the chosen year/month.
- Exclude Sundays in calculation. 
 
Filter Month: 2019/11

Data that needs to be reflected is from Nov 1, 2019 to Nov 30, 2019 only. 

3.
Add a slicer wherein "yyyy/wk" and it will get data from the start of the week until end of that week only.
At the same time it will show the days of the filtered week.
Note:
- yyyy/wk basis here is the "StatusDateEnd" column
- It also needs to exclude Sunday in calculation.

Filter Week: 2019/46

4. It also needs to show filler weeks wherein it will show weeks from the month filter stated in no. 1. Even if the StatusDateEnd is Nov 12, 2019, it needs to cover the start until end of the month based in no. 1
Filter Week: 2019/45

The final output would be if filtered for year/month 2019/11:
Filter month: 2019/11
Filter week: All 

Note: There are some entries wherein a certain equipment will have multiple entries for that month. I need calculations for each of that entry and have a filler entry that will cover the date range. There should be no overlaps.

Appreciate your kind help. 

Best regards,
Mark