I have rows/columns of times that looks like this:
<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!
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!