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
PascalKTeam's avatar
PascalKTeam
Iron Contributor
Jan 19, 2020
Of course this can be done. Would a macro solutions be OK?
  • 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!

Resources