New problem with summing time gaps & conditional formatt

[=HPSF=RMP]

Hello,
I am wanting to create a cell that will sum up any time gaps over 10 minutes on a list and highlight the gaps.

Here is an example of the cells.

Activity_Time
11/21/2005 11:08
11/21/2005 11:17
11/21/2005 11:17
11/21/2005 11:21
11/21/2005 11:25
11/21/2005 11:28
11/21/2005 11:30
11/21/2005 11:38
11/21/2005 11:39
11/21/2005 11:59

On this list there would be one gap totalling 20 minutes. The 11:39 to 11:50 gap. Everything else would be ignored being under 10 minute gaps.

Is there a way to create a cell next to this that would highlight these gaps and then sum the total string of gaps??


any help would be appreciated.
thanks!!

 

[=HPSF=RMP]

New Problem

There is a flaw in this formula. Here is the example:

11/28/2005 16:32 FALSE 0:00:00
11/28/2005 16:35 FALSE 0:00:00
11/28/2005 17:44 FALSE 0:00:00
11/28/2005 17:47 FALSE 0:00:00

If you notice, there is 1 hour 9 minute gap, but since the minute is only 9, it is still showing FALSE. I tested this by changing the time from 16:35 to 16:33 and it calculates since the minutes is over 10.

Here is the formula that was used.

=MINUTE(B140-B139)>10

 

[Andrew Poulsom]

Re: New Problem

There is a flaw in this formula. Here is the example:

11/28/2005 16:32 FALSE 0:00:00
11/28/2005 16:35 FALSE 0:00:00
11/28/2005 17:44 FALSE 0:00:00
11/28/2005 17:47 FALSE 0:00:00

If you notice, there is 1 hour 9 minute gap, but since the minute is only 9, it is still showing FALSE. I tested this by changing the time from 16:35 to 16:33 and it calculates since the minutes is over 10.

Here is the formula that was used.

=MINUTE(B140-B139)>10

I didn't anticipate that large a gap given the original data you posted. Try:

=((HOUR(B140-B139)*60)+MINUTE(B140-B139))>10

 

[=HPSF=RMP]

perfect!!
thanks so much!