Formula for obtaining the total running time from the time code

Thank you very much for you advise. However, it does not seem to be working.

I should have been more thorough in my original post. The values in each cell are HH:MM:SS:FF (HH=hours, MM=minutes, SS=seconds and FF= frame). In the sample file, the frame rate is 30, which means when FF is 30, it carries over to SS. You will never see 30 in FF. If the frame rate is 24 you will see only 00 through 23 and 24 will carry over to MM.

You'll see only 00 through 29. In SS (seconds) and MM (minutes) you will see only 00 through 59.

When I do the addition manually, the total duration is 00:18:13, rather than 01:11:13:00 which I get from your formula.

I hope the above information is helpful in revising the formula.

Thanks again for your time and help!

Thank you for your time and yes, you are right. The sum should be 1:18:30. It was a typo. Thank you for catching that.

I did post the previous thread and it worked fine with the sample file. However, when I used it with far more rows in real projects, I noticed that the results were not always correct. It was inconsistent (sometimes it was correct and sometimes it wasn't). So I ended up having to verify the results manually. I was not sure if I could re-open the resolved thread. In the meantime, I was given a different template with a new formula but it does not have the total sum formula and I am having to do it manually.

I am still a very beginner and this is way over my head at this point. So, I was hoping that I could get some help.

Thank you in advance for your patience and guidance. Sincerely.

Thank you for your reply. I have attached the screen shot of the result being 01:11:13:00 rather than 1:18:13.

I will look for the inconsistencies from before with the previous formula.

Thank you.

Here is one example in which there are 168 rows. What I did was... I inserted additional rows to the original template you prepared for me to accommodate more rows, dragged the lower right corner of the last duration cell of the original template all the way down to the new last duration cell. The duration of each row was fine, but the total duration is supposed to be over 12 minutes.

When I had over 300 rows in another project, the end result was very different from what was supposed to be.

I would appreciate it if you could take a look at it.

Also, what is the most appropriate way to ask a question when a thread is already resolved?

Thank you very much for your help.

As I am reading/watching some basic tutorials, I have just noticed the critical error I made. I think I should changed the "end" cell number in the formula for in the total duration. Is this correct?

Do I change this number manually each time? Or, is there a smarter way to do this?

I apologize for my slow learning curve. Working, raising children and studying all at once seem to slow me down.

THANK YOU SO MUCH.
I appreciate your thorough explanations. It is finally making sense to me.
I truly appreciate your patience. You are very kind. Thank you.