Hello,
The scenario is this... if this is too hard to implement, I probably won't be given the go-ahead to develop. BUt, if it is not too hard to program, perhaps I can do it fast and get a huge improvement in preparation time of a report. I have a fair amount of access skill, and a little VBA...
Report is this (these steps currently being done in Excel, with over a thousand human inputs - process was NOT designed by yours truly ) Goal is to prepare this data prior to being exported to Excel for final formatting, arrangement, presentation etc.
Relevant steps:
(Spreadsheet contains a listing of all records keyed by each person, with a date/time stamp. However, there is no time-stamp for when the record was begun, unlike a call-log. The below steps are an effort to see how long it took to do each individual record)
Preparer filters for rows where the time-gap between two rows is greater than 45 min.
one then inserts two empty rows between said rows.
then the Word "Project" is pasted into several columns of that row. the goal is to associate outlier time-gaps with "Project" time or saying "I was working on something that can't be tracked in this manner, or was out to lunch or the dentist"
One must then insert the date/time from the above row into the first "project" row, and insert the date/time from the next row of data, into the above row.
Once that new timestamp has been added to the project time rows, the gap now becomes associated with them, and not the person who apparently left the office for around an hour, and returned.
My desire is ultimately to revamp this entire process, cuz it stinks. But for now, if I can determine how to prevent a person from needing to first, input 100+ pairs of empty rows, grab the preceding or following date/time as prescribed, then this would cut down on a huge potential for human error, and take a lot of the preparation time out of this report.
Please ask clarifying questions if needed. Thanks!