Forum Discussion
How to add a clock or timer in Excel to measure how long until a field has changed
Hello,
I have a spreadsheet with a "status" drop down and I would like to see if there is a way to be able to track how long it has been in certain statuses. For example, when a record is first added it would have a status of "Unassigned" and I want to track how long it was in this status before it went to a status of "Under Review" and then how long it was in this status before it went to a closed status.
I hope what I am trying to do is clear and appreciate any help.
Thank you
8 Replies
- You can set up 2 data tab -
- 1st data tab is your Current Day data set, and
- 2nd data tab is Previous Day data set.
Every day when you run your report -
1. Replace data set in Prev. Day with data in Current day,
2. Update Current Day data set, and
3. Compare the status of same record between current day and previous day. If status of a record has changed, record the date of current day.
Macro would be very helpful when moving and updating data sets. - Of course this can be done. Would a macro solutions be OK?
Hi PascalKTeam,
I think a macro solution would be good. I have dabbled in macros and was looking around online initially how to do this, but did not find something that was the similar to what I need to do.
Are you able to give me some suggestions on how to do this with a macro?
Thank you!
Hi szub_2
The attached file shows the principle of how this can be done. just play around with it by changing the status dropdown in the yellow cells. I hope this helps
