CR 2008

< ="Content-" content="text/; charset=utf-8">< name="ProgId" content="Word.">< name="Generator" content="Microsoft Word 9">< name="Originator" content="Microsoft Word 9"><>

Table.Create_Date

1/4/2010  12:40:29PM  =  0 min (start of first record)

1/4/2010  12:42:24PM  =  2 min

1/4/2010  12:43:15PM  =  3 min running total

1/4/2010   2:18:05PM   =  0 min (reset due to 93 minute break)

1/4/2010   2:20:15PM   =  2 min

1/4/2010   2:24:34PM   =  6 min running total

 

TOTAL TIME              =  9  (3+6)

 

How can I write a formula to calculate the total time spent.

 

If there is less than a 10 minute break between previous and next Create_Date then continue the running total, otherwise reset the running total to zero.

 

I don’t care if the seconds are utilized or not.