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...

excel

Formulas and Functions

office 365

m_tarler
Apr 27, 2026
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

m_tarler

Silver Contributor

Apr 27, 2026

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

Bluemoon613
Occasional Reader
Apr 27, 2026
I was having so much trouble because I was using this method before and it kept giving me "false negatives." I changed the formatting to 24-hour clock and that seemed to solve the issue! Thank you for your help!

Forum Discussion

Overlapping times within one row