|
have users work experience in database
Position Field, Employment Period(from,to)
IT Jan 1982 - Feb 1984
Advertizing Mar 1985 - Feb 1990
IT Jan 1990 - May 2002
IT Jan 2007 - Aug 2007
I need to calculate total work experience in IT, Advertizing.........
and I need to get values in this vay for example IT- 12.8 it means that 12 years and 8 month in IT.
|