Solved: Total sum of Time in a column

[Barryj]

I have 14 rows in column A which I want to have the total sum for.

The cells are custom formated to h:mm and the are at least 4 blank rows in the column maximum 5, the blank rows vary depending on the amount of shifts worked per fortnight.

When I tried a simple SUM formula it only count the rows till the first blank row, not the actual time.

Can anyone help with a formula that skips the blank rows and adds the actual hours up.

Have included a example to help assist.

Thanks

[fmcti]

This is because whenever the total reaches 24, it goes back to zero, as it is another day.

I also wonder how to get the total hour.

[mdmackillop]

Change the result cell format to [hh]:mm

[BrianMH]

Do a custom format on the sum cell.

[h]:mm

edit: beat to it again lol

[shrivallabha]

This is happening because we are still looking at Time and Not Duration. Something like:

=COUNT(A2:A15)*8
Should work with formatting retained as number and not Time.

[Barryj]

Thanks Mdmackillop that has solved that problem, I will mark thread as solved.

Thanks again.