Timer (that can be paused) to count the time elapsed on a specific task

I have created a Workbook where the users can enter the tasks to be performed.

I want to add a function that calculates the time elapsed and i have the following requirements:
1. When the cell value under "Status column" changes from "Open" to "WIP", the timer should start.
2. When the cell value changes from "WIP" to "Pause", the timer should stop.
3. When the same cell value returns to the value "WIP", the timer should resume from where it had paused.
4. When the cell value changes to "Closed", the timer should finally stop and tell the total time elapsed on the task.
5. The timer should keep running even if the excel file is closed (Because i am not able to give access to multiple users on the same file).

Can anyone help me please?

Hi Torachan,

thanks for reaching out. I am uploading a sample worksheet to depict what i really want.

I have prepared some step to serve tea.

I have added status and time elapsed for each line. I will explain each element.
1. Column A obviously the s.no. and Column B is the task to be performed.

2. Column C is for the status of the task.
- Open: Task not started yet
- WIP: task ongoing
- Paused: task started and stopped to do something more urgent. will get back to this task again.
- Closed: task finished.

3. Column D is for time elapsed.
- p is showing that the timer is paused and "p" amount of time has elapsed. when the status changes to "WIP", timer will resume to show a + <time>
- q timer is on and is showing that that "q" amount of time has passed since i started that task.
- r (and t) are showing that the task hasn't started. this might as well be zero.
- s has the timer off and shows i took d amount of time to finish the task (excluding the time i "paused").

I want to say that i don't want to see an animation of an ongoing clock really.
It is just that when i take extract a report, i should be able to see how much time i have spent on each task.

So if i want to summarise, I just need the time from the point the status changed to WIP until the status changed to Closed exclude the time i had "paused".
Also, this task might go for multiple days.

Please tell me if i am not clear...
Do you have a solution to this?