Best way to add Times

[duugg]

I have a bunch of recordings on my DVR. So I put the titles and description onto a spreadsheet each in their own column. Then I created a "length of time" column. So why, in this attached spreadsheet, does the "grape" total autosum all the rows in that column correctly but the "cherry" total does not total it's column correctly?

I looked at the format of all cells in both columns and they are both set at h:mm.

Here's a copy of the spreadsheet...



Does anyone know why this is?

Thanks

[protonLeah]

Change the format of the totals cells to: [h]:mm

[shg]

Format the results as [h]:mm to see other than the residual hours.

[duugg]

Worked perfectly, thanks. Any idea why the 2 columns in the spreadsheet return values differently even though the format is the same?

[shg]

The format is not the same.

[duugg]

Okay, I'll check it out.

Thanks again.