I am creating a spreadsheet that calculates a person's time on the
job.

It looks like this

Inclusive Dates (Begin) Inclusive Dates (End) Totals
1/27/1996
3/20/1996 0 years, 1 months, 22 days
Inclusive Dates (Begin) Inclusive Dates (End)
3/21/1996
2/6/1998 1 years, 10 months, 16 days

It already calculates the time between the Inclusive Dates (Begin) and
Inclusive Dates (End), now i want it to total to totals into a block
which reflects the same way like:

Inclusive Dates (Begin) Inclusive Dates (End) Totals
1/27/1996
3/20/1996 0 years, 1 months, 22 days
Inclusive Dates (Begin) Inclusive Dates (End)
3/21/1996
2/6/1998 1 years, 10 months, 16 days


Final Total

2 years , 0 Months, 8 days

It will need to sum the two formulas. equalling the current column
totals
=DATEDIF(B4,C4,"y") & " years, " & DATEDIF(B4,C4,"ym") & " months, " &
DATEDIF(B4,C4,"md") & " days"
And
=DATEDIF(B6,C6,"y") & " years, " & DATEDIF(B6,C6,"ym") & " months, " &
DATEDIF(B6,C6,"md") & " days".

Can anyone help? Please. You can also email me at


Thanks.