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