Forum Discussion

Sven01's avatar
Sven01
Icon for Helper I rankHelper I
8 years ago

Need Help - calculate relevant occupancy datetime

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...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

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