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 ...
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.
- 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.