I'm working in SharePoint 2007 Document Library, where there is a Choice column named Status, with a value of Assigned, In Progress, Closed.
I wanted to capture the time taken of document status change.
time taken to change from Assigned to In Progress
time taken to change from In Progress to Closed
workaround I can think of at this moment is either using SharePoint Designer workflow or Event Handler to trigger the item created event and item modified event, then stored the item into a Custom List and calculate the time different.
any better approach to implement the requirement above?
thank you in advanced :)