How to calculate elapsed time between status changes ?
Is there a way to calculate the elapsed time between two status changes ? I would need to know how much time it took for the status to change from yellow or red to green.
Ideally, I would like to be able to calculate a mean per territory, department and my whole plant on time between yellow/red to green status change.
Here's a view of the source sheet
And the report from that source sheet
Help Article Resources
Check out the Formula Handbook template!