Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   calculate total work experience by Position Field (http://www.go4expert.com/forums/calculate-total-experience-position-t22507/)

 Mariam 23Jun2010 12:32

calculate total work experience by Position Field

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.

 shabbir 23Jun2010 13:52

Re: calculate total work experience by Position Field

Fetch all the dates and arrange them in chronological order and then get the time between first and last.

 Mariam 23Jun2010 14:33

Re: calculate total work experience by Position Field

Quote:
 Originally Posted by shabbir (Post 69534) Fetch all the dates and arrange them in chronological order and then get the time between first and last.
It will no work properly.

What if I have

IT Jan 1982 - Feb 1985
IT Jan 1983 - May 1986
IT Jan 2001 - Aug 2007

You say 2007-1982=25
but the correct is 10

 shabbir 23Jun2010 15:09

Re: calculate total work experience by Position Field

Was he sleeping between 86 and 2001?

But anyway then you have to be adding each row.

 Mariam 23Jun2010 15:46

Re: calculate total work experience by Position Field

Quote:
 Originally Posted by shabbir (Post 69539) Was he sleeping between 86 and 2001? But anyway then you have to be adding each row.
Yes he was sleeping between 86 and 2001.

 shabbir 23Jun2010 16:08

Re: calculate total work experience by Position Field

Then add the difference between each row.

i.e end - start and then sum all for total experience

 Mariam 23Jun2010 16:18

Re: calculate total work experience by Position Field

Quote:
 Originally Posted by shabbir (Post 69545) Then add the difference between each row. i.e end - start and then sum all for total experience
Look if I have

IT Jan 1982 - Feb 1985
IT Jan 1983 - May 1986

1985-1982=3
1986-1983=3
I sum up and get 6.
But 4 is correct answer.

 shabbir 23Jun2010 17:14

Re: calculate total work experience by Position Field

But then you are not just add each years that way. His year of work should not overlap as well so you have to make addition like this.

1982 12 months
1983 12 months
1984 12 months
1985 12 months
1986 5 months

And this would give you results.

You have to b adding months for each year and then see how many months he has actually worked for the whole of his life.

This would mean if he is not working for few years that months would also go away.

 Mariam 23Jun2010 18:13

Re: calculate total work experience by Position Field

Quote:
 Originally Posted by shabbir (Post 69550) But then you are not just add each years that way. His year of work should not overlap as well so you have to make addition like this. 1982 12 months 1983 12 months 1984 12 months 1985 12 months 1986 5 months And this would give you results. You have to b adding months for each year and then see how many months he has actually worked for the whole of his life. This would mean if he is not working for few years that months would also go away.
I need an example. I have already tried different way, but unsuccessfully.:embarasse

There are times that some months,years are missed.

 shabbir 23Jun2010 19:04

Re: calculate total work experience by Position Field

Say You have a GRID where each row is a year and each column is a month.

Now from 1982 to 1986 loop through all the months and see if that month he was working or not and if he was then assign a flag in the grid.

No of flags in the grid is the total number of months he has worked for.

 All times are GMT +5.5. The time now is 19:20.