Calculating Date Time Stamps for duplicate ID's
I am tasked to create KPIs for how long it takes for an ID to sit in a specific status. Attached is a snippet of sample data for reference.
The amount of days for the first "status change time' would be taken from the 'HRC Create date', or when the ID was created, the rest of the changes would be the difference between each status time change and stop after there is a new ID.
What would a beast mode look like to calculate the amount of days between each time change per ID #?
Thanks in advance.