Summing Time Not Working

[salameda]

I have rows/columns of times that looks like this:

Date	Scheduled Appt Duration	Actual Appt Duration	AQR Appt Duration
12/1/17	6:00	4:37	5:03
12/4/17	0:00	0:00	0:00
12/5/17	6:00	5:02	7:10
12/6/17	5:30	2:14	2:34
12/7/17	6:00	4:00	4:46
12/8/17	0:00	0:00	0:00
12/11/17	6:00	2:01	4:02
12/12/17	2:15	2:17	2:16
SUM	751:45	20:11	25:51

<tbody>
</tbody>

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.