Average tenure of multiple employees

[Krishck]

Hi All,

I did tried to lookup but couldn't find anything. I am trying to take average of employees within organization however, there are certain employees who has worked in multiple jobs within organization and that it causing. I am attaching a sample dataset

[#2]

@Krishck You can use SUMIF to sum the tenures of each employee and then average it. See attached.

[#3]

Hi Riny_van_Eekelen Thank you for the response. That is what I am looking at.

Quick question: As of now, we are in 2016 not moved to 365, any chances of achieving this in 2016?

[#4 · Accepted solution]

@Krishck Just create the list of unique employee names manually or use the formula added in column K in the attached file.