Summing Time Not Working

[salameda]

I have rows/columns of times that looks like this:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Scheduled Appt Duration[/TD]
[TD]Actual Appt Duration[/TD]
[TD]AQR Appt Duration[/TD]
[/TR]
[TR]
[TD="align: center"]12/1/17[/TD]
[TD="align: center"]6:00[/TD]
[TD="align: center"]4:37[/TD]
[TD="align: center"]5:03[/TD]
[/TR]
[TR]
[TD="align: center"]12/4/17[/TD]
[TD="align: center"]0:00[/TD]
[TD="align: center"]0:00[/TD]
[TD="align: center"]0:00[/TD]
[/TR]
[TR]
[TD="align: center"]12/5/17[/TD]
[TD="align: center"]6:00[/TD]
[TD="align: center"]5:02[/TD]
[TD="align: center"]7:10[/TD]
[/TR]
[TR]
[TD="align: center"]12/6/17[/TD]
[TD="align: center"]5:30[/TD]
[TD="align: center"]2:14[/TD]
[TD="align: center"]2:34[/TD]
[/TR]
[TR]
[TD="align: center"]12/7/17[/TD]
[TD="align: center"]6:00[/TD]
[TD="align: center"]4:00[/TD]
[TD="align: center"]4:46[/TD]
[/TR]
[TR]
[TD="align: center"]12/8/17[/TD]
[TD="align: center"]0:00[/TD]
[TD="align: center"]0:00[/TD]
[TD="align: center"]0:00[/TD]
[/TR]
[TR]
[TD="align: center"]12/11/17[/TD]
[TD="align: center"]6:00[/TD]
[TD="align: center"]2:01[/TD]
[TD="align: center"]4:02[/TD]
[/TR]
[TR]
[TD="align: center"]12/12/17[/TD]
[TD="align: center"]2:15[/TD]
[TD="align: center"]2:17[/TD]
[TD="align: center"]2:16[/TD]
[/TR]
[TR]
[TD="align: center"]SUM[/TD]
[TD="align: center"]751:45[/TD]
[TD="align: center"]20:11[/TD]
[TD="align: center"]25:51[/TD]
[/TR]
</tbody>[/TABLE]

The times are pulled from another worksheet in the workbook.

I want to sum the columns to show the total hours and minutes, but I keep getting a really incorrect answer at the end of the columns. The first column should add up to 31.45.

The SUM cell formula is =SUM(B2:B21) and it's formatted as [h]:mm. HELP!

 

[James006]

Hello,

It looks as if in the column to the right ...20:11 is correct ...

Have you tried to copy from this cell back to the previous one ...???

 

[KevCarter]

Double check your formatting. I copied your text to a spreadsheet, and got the same result. I then reformatted the problem cell to [h]:mm, and got 31:45.

 

[macattackpro]

I would check formatting and the formula as suggested. I copied your table into a new sheet and re-did the formula then made sure it was formatted properly and I got 31:45.