Product Hacks

Process Lead Time

Process Lead Time
Userlevel 5

Have you ever heard of ProccessLead time? Process Lead time is the amount of time between the start of a process and  its conclusion. In other words, it’s the amount of time from a card creation until it reaches an end phase of the process.

 

To check you process lead time For that, you must create a report with the following information: : “Created at” and “Finished at”. 

v7UNdeWlidhNWLPYPhi9sv-3HIaNzjRc2BO76gX6CnmcgFdj3JcAY7JPgx0PsCZkSLtepq7Bk19xZ8KdhMGbEJTklKxX-_KPKa4xGcgnAO2Zpd-kY1L_yfwR3Kp95ozt8qEO6jA7

After selecting both columns you can export it to excel by clicking on MOgPsF42ZJeYMsJcC4QtifZbomv2kc-kafzAJLuSCa_VOVTO6TsfALxFmPV5oHQ7cxJuKCswxXh8Z7vIyAxqLUOVVmgi12v1dS8Kyy5KUjbq5uR4NSMdu1s18jKaoJJYEwkMUaTG

 

Nexct,  open the Excel file, add a new column called  “Lead time” and on the cell add the following formula:  =Finished at - Created at

 

The result will be the number of hours or days a card spent to go from the first to the last phase of your process. You can apply this formula to all records of cards in the spreadsheet and at the last cell  you must add the following formula to get your process lead time: =AVERAGE(cells range)

 

The final result will be your process lead time.. 

 

Ps. It’s important to mention that for cards that aren’t finished yet, time is still counting.


0 replies

Be the first to reply!

Reply