Need Help - calculate relevant occupancy datetime

[Sven01]

Dear Experts, dear Forum,

my table contains three colums. Position, Arrival and Departure. Sample DATA  What iam trying to calculate is the occupany time of eatch Position in a relavant timeframe which is for example from 9pm to 3am on eatch day of the year. The goal is to get a visual whitch i able to drilldown starting from total occupancy hours of the total year, than in month, day and at least the occupancy hours of that day but splittet into the Position of the day. 

My approach would be to generate a new tabe with colums: Start date of relevant timewindow, Position, hours of occupany in relevant timewindow. 

I already posted the issue some days ago but couldn´t find a 100% sufficiend solution: Previous Post

Thank you in advanced for your time and help

[v-juanli-msft]

Hi @Sven01

Untill now, I can only calculate the all occupancy time for each position in the relavant timeframe which is from 9pm to 3am on each day of the year.

Best Regards

Maggie