Multiple timespans

[fedfed]

I have about 50 timespans.
Each is formatted to have start time in column A and end time in column B (DD/MM/YY h:mm).
I also have a list, with about 850 rows timestamped (same format).
I need to mark all rows which fall in one of the ranges.

Thanks in advance.

[mrice]

If Start times are in column A and end times in column B and the time is in E2 then

=COUNTIFS(A:A,"<" & E2,B:B,">" & E2)

will count how many of the timespans cover the time in E2.

I note that you might not have access to a later version of Excel so you might consider just posting the times so that a more recent version can be used. COUNTIFS is a relatively new addition to the set of functions.

[fedfed]

Thanks for your solution. I can't test it yet, but I think it'll work.

I have a later version of Excel, my profile is a bit outdated