Calculate time within time

F

Frigid

Hi there,

Is there a formula that will calculate time within time? For example in A1
& B1 I have:

11:00- 11:30

In A2 and B2 I have:

10:55 - 11:05. I want to return the number of minutes of this that is
within the times on row 1 (five).

Thanks in advance!
 
B

Bob Phillips

=MIN($B$1,B2)-MAX($A$1,A2)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Top