Timers & Stop Clockfeature in Excel

[xl_newbie]

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.

 

[Arcticwarrio]

maybe you could use this somehow

=TEXT(NOW(),"dd-mm-yyyy HH:mm:ss")