Hi, please help me in calculating in Excel the total experience of an employee. The data I have includes their past experience in years as 1, 2, 2.4, etc., and present experience calculated from the Date of Joining (DOJ). I would require the sum of previous experience and the experience in the company as Total Experience, which must be updated regularly as per the system clock.
Quick help on this issue is highly appreciated.
Thanks,
Jyo
From India, Hyderabad
Acknowledge(1)
Amend(0)
2Quick help on this issue is highly appreciated.
Thanks,
Jyo
From India, Hyderabad
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Employee Experience.doc
SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls