Compare Two Dates/Times for Time Window Match (ie are they both in a 20 min window)

Howdy,

I'm a little stuck, dates and times are not my strength in excel

I have two cells in excel

A1 = 16/02/2011 16:14
B1 = 16/02/2011 16:33

Is it possible to work out the following:

1. How many minutes difference are between these two
2. Then to find matches where they are within say a 20 minute window of each other?

Many thanks,

Matthew

Try B1-A1 formated as [m]:ss

For 2nd can you give some further explanation, or even better, upload example workbook?

Originally Posted by zbor

Try B1-A1 formated as [m]:ss

For 2nd can you give some further explanation, or even better, upload example workbook?

Hi,

See attached.

I'd like to know the time difference between the two dates/times. ie in this example, 20 minutes.

Matthew

Check this:

Originally Posted by zbor

Check this:

Ah you have a filter [m] LOL, that simple !!!

Many thanks,

Matthew