Hi there
I need to sum timecodes to give a total time of a particular subject/ person in a program. However, excel won't allow me to do this as my cells are in the format hh:mm:ss:ff with frame rate at 25fps.
Any help would be hugely appreciated.
Thank you
If you're looking to sum a number of rows simultaneously without helpers you might try something along the lines of:
the above would return an hh:mm:ss:ff result
Please Login or Register to view this content.
No doubt a simpler approach but feeling a bit thick at the moment...
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks