HR Analytics – Excel – Time in Role / Department / Location Analyse and calculate the amount of time each employee stayed in a role, department, grade, or any other parameter you have. Use Pivot Table + Calculated Column + Conditional formatting Read ยป