Macro needed for time calculation and auto insert
Hi,
Looking for some help with a macro for a huge batch of data I've got to plough through....
I've been tasked with calculating some task processing times. I'm therefore hopeful someone knows of a macro or two which could a) indentify a starting and ending point, b) insert a row after the end point and then c) calculate the time between start and end point. There is a further problem in that tasks started and completed overnight show as an error, so bonus gratitude if anyone knows how to counter that.
I've attached a small sample of data to show what I'm working with, highlighting the start point in green and the end point in red. Column E contains the data for the start and stop, so in this instance would be "NEWCASE" and "Notify Parties Application Received - Early Notification Letters Sent. Move on to Recommend Track"
For the example I have manually inserted the cell and calculation in the example data, but would be grateful for any pointers on how to automate that process as we have tens of thousands to get through.
Thank you for looking.
Ballst
|