Totalling Formulas
 

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.

Totalling Formulas
 

I would add a column that has the inclusive dates in days beside the one you
have in words. =A5-A4. You can then just sum the new column =sum(D1:D100).
Then use DATEIF like you are doing in your datedif formula. Use for the
first parameter in your function datavalue("1/1/1900").

time inmicrosoft starts at 1/1/1900. If you subtract 4/8/07 - 4/7/07 you
get one day which is equivalentt to 1/2/1900. So if you add 1/2/1900 + 3
days + 7 days + 5 days you get 1/16/1900. Your total days will be 1/16/1900
- 1/1/1900 which you can convert to 15 days.

" wrote:

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.