Hello,
Need expert advice on timer & stop clock features for computing elapsed times.
Context:
I work as an IT Service Delivery Mgr and I need to track incidents and their elapsed times. I know this feature is in-built in most of the incident management tools, but unfortunately we dont have a tool and we have started doing it in an excel sheet.
The fields that I have captured in the excel sheet are:
Record # (Primary Key - unique - but can have multiple iterations since I have to track them)
Status: (iterations are based on this field - values: Open/Open Solving/Pending User/Pending 3rd Party/Resolved)
Creation Date:
Creation Time:
Acknowledge Date:
Acknowledge Time:
Resolved Date:
Resolved Time:
SLA Met/Not Met: Based on the time taken to resolve, compared with the time alloted/agreed.
The clock needs to stop/start whenever the status changes.
Sorry for such a lengthy problem description, but would appreciate if someone can help!
Thanks much.
Need expert advice on timer & stop clock features for computing elapsed times.
Context:
I work as an IT Service Delivery Mgr and I need to track incidents and their elapsed times. I know this feature is in-built in most of the incident management tools, but unfortunately we dont have a tool and we have started doing it in an excel sheet.
The fields that I have captured in the excel sheet are:
Record # (Primary Key - unique - but can have multiple iterations since I have to track them)
Status: (iterations are based on this field - values: Open/Open Solving/Pending User/Pending 3rd Party/Resolved)
Creation Date:
Creation Time:
Acknowledge Date:
Acknowledge Time:
Resolved Date:
Resolved Time:
SLA Met/Not Met: Based on the time taken to resolve, compared with the time alloted/agreed.
The clock needs to stop/start whenever the status changes.
Sorry for such a lengthy problem description, but would appreciate if someone can help!
Thanks much.