Results 1 to 5 of 5

Adding Minutes/Seconds to SMPTE Timecode

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2020
    Location
    London, UK
    MS-Off Ver
    2010,2013,2016
    Posts
    3

    Adding Minutes/Seconds to SMPTE Timecode

    Hello Guys,

    First post, but have used your helpful forum many times before to find answers!

    I'm a little stuck with this one, and i'm reaching out for help!

    I am trying to calculate a Final Timecode Value, for the end of a track.

    In cell A2, I have the starting timecode value, formatted as text in the style of HH:MM:SS:FF
    In Cell B2, I have audio track length, formatted as MM:SS
    In Cell C2, I would like the final Timecode End Value...
    Currently all timecode is 25fps, so no requirement to change that or account for that changing just yet...

    So for example:

    01:10:00:19 | 02:09 | 01:12:09:19
    01:20:00:15 | 01:33 | 01:21:33:15

    Is what i'd be after...

    Any help would be amazing, would be willing to split cells, then concatenate etc if required, then hide cells etc... anything just to get this thing working!!
    Attached Files Attached Files
    Last edited by tdcist; 02-19-2020 at 11:26 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Subtracting SMPTE timecode
    By jayduerrmusic in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-14-2013, 01:29 PM
  2. [SOLVED] Adding minutes and seconds to get elapsed time
    By lokam_dad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-13-2013, 10:01 AM
  3. Adding Time, Minutes & Seconds
    By critter4511 in forum Excel General
    Replies: 6
    Last Post: 04-03-2012, 06:41 PM
  4. Adding minutes and seconds in separate columns
    By excel2007student in forum Excel General
    Replies: 4
    Last Post: 10-08-2011, 07:57 AM
  5. Adding Minutes:Seconds
    By jayduerrmusic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2008, 05:31 PM
  6. [SOLVED] Adding hours minutes and seconds
    By WannaChevy03 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-01-2006, 10:45 AM
  7. [SOLVED] [SOLVED] Adding minutes & seconds
    By Emily16 in forum Excel General
    Replies: 5
    Last Post: 10-13-2005, 05:05 PM
  8. Does anyone have a formula for SMPTE timecode in Excel?
    By taverett in forum Excel General
    Replies: 1
    Last Post: 07-20-2005, 04:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1