Calculation of time isn't calculating correctly...

[machinegod]

I'm trying to calculate the total time in the table I set up, but for some reason it is rounding the time. How do I prevent this from happening?

[joeu2004]

=SUMPRODUCT(D5:D24-C5:C24) should be =SUMPRODUCT(D5:D25-C5:C25)

PS....

1. Actually, the ranges should extend to row 28, IMHO.

2. I'm not a tables person. But I suspect there is some Table170[@[Time Out]]-like notation that would sum the entire column by name instead of enmuerating the row numbers. That would expand the sum automagically if/when you expand the table. Hopefully, a tables person will jump in with that solution.

[machinegod]

=SUMPRODUCT(D5:D24-C5:C24) should be =SUMPRODUCT(D5:D25-C5:C25)

PS....

1. Actually, the ranges should extend to row 28, IMHO.

2. I'm not a tables person. But I suspect there is some Table170[@[Time Out]]-like notation that would sum the entire column by name instead of enmuerating the row numbers. That would expand the sum automagically if/when you expand the table. Hopefully, a tables person will jump in with that solution.

Thank you.