How can i find team name above and count the time since last game

[Ipinho100]

Hi

I want to count the time since home and away teams have had their last games. What is the formula i should but in the cells e2 and f2?

Thanks for the help already...

[:) Sixthsense :)]

What is the expected count (result) of E2 & F2?

[GIS2013]

Hi. Something like that?

[Ipinho100]

F5 should be 25 hours, the data is from the beginning of the season so other teams have not played earlier...so all the other cells in columns e and f should be empty...

[GIS2013]

I'm not sure I've understood you, but now they're empty.

[Ipinho100]

Hi

It does not work as i was thinking. I try to make it clearer..

E2= i try to find philadelphia from cell e1 or f1 and if i do find it i count the time difference between the matches.
F2= i try to find toronto from cell e1 or f1 and if i do find it i count the time difference between the matches.
E3= i try to find detroit from cell e1,e2 or f1,f2 and if i do find it i count the time difference between the matches.
F3= i try to find buffalo from cell e1,e2 or f1,f2 and if i do find it i count the time difference between the matches.

And so on, so i try to find the team name from above and calculate the time difference between the matches...

[GIS2013]

I'm still not sure I understand. Better add a table with results as they should be appeared.