Thank you for the code, I have almost got what I need. The math seems to be correct, except the calculation provided is assuming the prior claim is an "open" time stamp. I need the flip side of that, where, if MDLegran closed a claim at 8:48:42 AM and the prior claim that day was closed at 7:49:53 AM, then the row with 8:48:42AM should show the 0:58:49 as the "Time to Work". As it stands with the provided code, it's showing 7:48:06 AM as 58:49. Does that make sense? Below is what I'm seeing and below that will be what I want to see.

Current provided code result:
95 11319BZ4349 5/1/2013 7:49:53 AM 0:58:49 30 MDLegran
814 12291980048 5/1/2013 8:48:42 AM 0:57:53 645 MDLegran

What I need it to look like:
95 11319BZ4349 5/1/2013 7:49:53 AM 0:25:30 30 MDLegran
814 12291980048 5/1/2013 8:48:42 AM 0:58:49 645 MDLegran (as you can see, it took 58 min to work this claim).

Thank you again for providing the code. I look forward having a solution to my issue