ColumnB is a list of times. ColumnC is True if the gap of time in ColumnB is greater than 10 Minutes. ColumnD will show that time gap greater than 10 Minutes and have no results for anything under 10 minutes.
The problem I have is I want to format the cells all the way down the column and protect it allowing the user to paste the activity time in. If you notice there is the #NUM! located in column D which wont allow me to SUM the whole Column D. It returns #NUM!. Is there a way to ONLY sum the actual numbers and ignore the #NUM!? I hope I explained this correctly.
thanks again
B C D
Activity_Time ID Gap
11/21/2005 19:20 TRUE 0:35:00
11/21/2005 19:55 FALSE 0:00:00
11/21/2005 19:56 FALSE 0:00:00
11/21/2005 19:56 FALSE 0:00:00
11/21/2005 19:58 #NUM! #NUM!
FALSE 0:00:00
FALSE 0:00:00
The problem I have is I want to format the cells all the way down the column and protect it allowing the user to paste the activity time in. If you notice there is the #NUM! located in column D which wont allow me to SUM the whole Column D. It returns #NUM!. Is there a way to ONLY sum the actual numbers and ignore the #NUM!? I hope I explained this correctly.
thanks again
B C D
Activity_Time ID Gap
11/21/2005 19:20 TRUE 0:35:00
11/21/2005 19:55 FALSE 0:00:00
11/21/2005 19:56 FALSE 0:00:00
11/21/2005 19:56 FALSE 0:00:00
11/21/2005 19:58 #NUM! #NUM!
FALSE 0:00:00
FALSE 0:00:00