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...
Hi lammec01 ,
You can split two column with "u", and then pivot them.
Repeat the operation for Column3.
Duplicate it and append them.
Pivot:
You can download my attachment for more details.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.