Forum Discussion
How to visualize occupancy over time
I have a basis excel file where per machine I have the start and end time of when it was "in use". I need a timeline (per hour) with the occupied time per machine. For example if a machine was in use...
Thanks for the response.
I am however missing still some data.
Machine 1 is in use from 10u00 till 11u30 and from 14u00 till 16u15.
I should get result like this
10u --> 60 min occupied
11u --> 30 min occupied
14u --> 60 min occupied
15u --> 60 min occupied
16u --> 15 min occupied
In your solution I am missing 15u timeslot.