Time Used per Interval

Hi All,

I am trying to put together a spreadsheet that will ideally show me how much time was used per interval.

Contraints:

- I only have the Start Time and End Time for an activity.
- Multiple entries per Interval (possibly and start of interval and another entry for the end of an interval) (Need to some both)
- Start Time can be in one interval and can end 3 to 4 intervals later as an example but could be more.

I have tried multiple possible solutions attempts but none of them has worked for me. I have even tried using the Floor and Ceiling for the start and end times but to no avail.

Could someone please help me.

I have attached a screenshot of what my data set looks like.

I am using 15 minute intervals for this project.

regards,
Murtadau

IntervalData.PNG