Overlap between two time ranges

Hello,

I'm trying to find an elegant (less caveman) way of calculating the overlap between two time ranges.

For example: No overlap, partial overlap, full overlap (enclosed) - ie returning just the time.

So if range 1 = 10:00 to 12:00 and range 2 - 14:00 to 18:00 there will be zero minutes overlap

but if range 1 = 10:00 to 15:23 and range 2 - 14:00 to 18:00 there will be 1:23 overlap

It can be calculated with columns of Ifs, but I want a tidy solution in just one column labelled "overlap"

Can this be done (possibly using sumproduct and some unary operations)?


Many thanks,
James