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!!
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!!