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

Subscribe to Blog

Join 1,747 other subscribers

Popular articles

Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.