Column A: Employee Name
Row 1: Column I: = TODAY()
Colum F:Start date: Actual date of hire
Column H: Total time in job: =DATEDIF(F4,$I$1,"Y")&" Years "&DATEDIF(F4,$I$1,"YM")&" Months "&DATEDIF(F4,$I$1,"MD")&" Days"
I need to sum the time for the employees from row 4 - 49 and take the average time in job.
then repeat for other job and create a graph for each job and highlight groups of employees with 0-6 months, 6 months - 1 year, 1 year - 2years..etc.
Can anyone help? I have the total time in the job calculated based on the formula above. not sure how to average the time among everyone or turn into a graph.
Row 1: Column I: = TODAY()
Colum F:Start date: Actual date of hire
Column H: Total time in job: =DATEDIF(F4,$I$1,"Y")&" Years "&DATEDIF(F4,$I$1,"YM")&" Months "&DATEDIF(F4,$I$1,"MD")&" Days"
I need to sum the time for the employees from row 4 - 49 and take the average time in job.
then repeat for other job and create a graph for each job and highlight groups of employees with 0-6 months, 6 months - 1 year, 1 year - 2years..etc.
Can anyone help? I have the total time in the job calculated based on the formula above. not sure how to average the time among everyone or turn into a graph.