|
|
#1
05-12-2015, 08:22 AM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Preventing Auto Metadata - Help Needed!
|
samcmakin | Word | 1 | 04-09-2015 11:48 PM |
|
How to prevent the auto-calculation of the '% Complete' field in MS Project Professional 2013?
|
VivekG1 | Project | 1 | 02-06-2015 05:33 AM |
| 'Monday to Friday' Date calculation help needed | ballst | Word | 10 | 12-16-2014 09:51 AM |
| Macro Needed to bold specific lines and Macro to turn into CSV | anewteacher | Word VBA | 1 | 05-28-2014 03:59 PM |
|
Macro Needed to Insert Asnwer to A Question in Multiple Choice Format Question
|
rsrasc | Word VBA | 7 | 03-28-2014 12:28 PM |
Windows XP 
Office 2003
Threaded Mode