Forum Discussion

DeepakJha23's avatar
DeepakJha23
Icon for Helper I rankHelper I
6 years ago

Time slots calculation between time ranges

I need some help regarding an issue that i am facing. I have a column Tag that represents a machine. And they have a RA_Time(start time) and RT_Time(Runs till/end time) with a schedule of Daily(runs...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I would create a time/ date table with [Time& Date} collumn

Then use If statement  to create a new custom column [ STatus] = IF [Time& Date] >= [Start Date] && [Time&Date] <= [Finish Date]  then "Busy" else "Free"

Then you could filter by first and last to give you the ranges . With this solution you would need to split the tables (per tag). 

There probably is a cleaner and more elegant way of doing this.