Forum Discussion
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...
Hi DeepakJha23 ,
If i understand you correctly,
1# Use DATEDIFF() function to calculate the time ranges per row.
2# Sum up the time ranges with same tags per day. You might use ALLEXCEPT() function.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.