Forum Discussion
Solved
Overlapping times within one row
Hello, What I would like to do is identify if two time ranges within the same row overlap with each other. My ideal end goal would look like: Start 1 End 1 Client Start 2 End 2 Servic...
you can try this:
= (endTime2 > startTime1) * (startTime2 < endTime1)
and if you want it to be specifically T/F insteas of 1/0 then just
= (endTime2 > startTime1) * (startTime2 < endTime1) = 1
note this does assume all your times are the same day and each end time > start time
you can try this:
= (endTime2 > startTime1) * (startTime2 < endTime1)
and if you want it to be specifically T/F insteas of 1/0 then just
= (endTime2 > startTime1) * (startTime2 < endTime1) = 1
note this does assume all your times are the same day and each end time > start time