Forum Discussion

szub_2's avatar
szub_2
Copper Contributor
Jan 14, 2020

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 ...
excel
szub_2's avatar
szub_2
Copper Contributor
Jan 20, 2020

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!

PascalKTeam's avatar
PascalKTeam
Iron Contributor
Jan 21, 2020

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

  • szub_2's avatar
    szub_2
    Copper Contributor
    Jan 21, 2020

    Hi PascalKTeam, 

    Thank you for file.  I think this should work for what I am trying to do. Did you use a macro and Visual Basic?  I am trying to replicate and I am not getting the same results.  Both dates for Under Review and Unassigned change when I update the status. 

     

    Will you please give me some detail of what you did to get the result?

     

    Thank you!

      • szub_2's avatar
        szub_2
        Copper Contributor
        Jan 22, 2020

        PascalKTeam ,

        Unfortunately, I am not able to view your video. I could get your file to work, but when I tried to recreate myself, it was not working.

         

        Thanks - szub

Resources