Time in stage is a property calculated on the fly in HubSpot's reporting, and isn't a deal property in the classical sense. HubSpot uses the most recent transition between stages to report on the time spent in a stage; if a deal moves between stages in this order:
5 -> 6 -> 5 -> 7
The time in stage for stage 5 will reflect the amount of time the deal was in stage 5 for the second time (i.e. the 5 -> 7 transition).
Time is Stage Calculation for Multiple stage instances
Thanks for the response.
So using my example, are you saying that the time my deal spent between 5 -> 6 would not be counted, and Hubspot would only calculate the time my deal spent between 5 -> 7 since it is the most recent ?