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

Download sample file from here

DATEDIF function syntax

Queries | Comments | Suggestions | Wish list