Video Timecode Field

[airship]

For video editing purposes, how can I input timecode into a field? The format could be either:

H:MM:SS (hours:minutes:seconds)
MM:SS (minutes:seconds)

In the article Supported format specifiers for DATETIME_FORMAT I found “Preset timestamp format”, but that’s a timestamp. My desired format is time duration, similar to a stopwatch.

Thanks!

[Scott_Ratner]

What about double digit hours?

[W_Vann_Hall]

For durations configured as ‘h:mm’, anything entered before the colon (’:’) is considered hours, regardless of the number of digits. (Well, at least for as many digits as I’ve bothered to test; presumably it breaks down at some point. ‘50000:20’ works out correctly to ‘2083 days 8:20’, so 5-digit hour values seem to work.

Tossing in a second colon confuses things — that is, for a ‘h:mm’ duration — but I’ve not quite figured out how. For durations configured for second or sub-second granularity, two-colon entries with multiple-digit hours work fine.

[Finn_Ross]

Can we have one for true video time code that includes frames as opposed to milliseconds? i.e: hours:minutes:seconds:frames
I imagine you would need to specify frame rate some where in order for time calculations to work properly.
This would be super helpful.

[Nimrod_Erez]

Adding timecode support will bring over so many more users. And just for clarity, timecode support means that a cell can be edited to support timecode in a specified frame rate (23.976, 24, 29.97, 30, etc.) so any duration and calculations on timecode yield proper results. A timecode cell needs to be in a HH:MM:SS:FF format under a frame rate system (as noted above). Please bring this functionality!

[Tommy_Asselin]

Hi Community,

I’m resurrecting this thread to add another precise request on the subject.

The Duration field type is nice, but it does not auto format the data typed in.

With hundreds of IN and OUT time to log from footage files, I’d love to just have to type the numeral digits without the :
So if I type 123 it logs 1:23, and if I type 10123 it log 1:01:23, for hours:minutes:seconds, etc. as it works for example in premiere or after effects when typing numbers in the timecode field.
That kind of auto-formating for timecode, with various framerates presets, would be wonderful!!

Another linked request that would be useful is to be able to import video files just to grab the metadata, without uploading gigabytes of videos, so its not necessary to type the files name, duration, source, etc. manually!

I’m still searching for something that does what I need. But still thanks for what airtable is already!

[airship]

Excellent suggestions for omitting the colon and metadata import! :clap:t2: :pray:t2:

[Justin_Barrett]

Tommy_Asselin:

With hundreds of IN and OUT time to log from footage files, I’d love to just have to type the numeral digits without the :
So if I type 123 it logs 1:23, and if I type 10123 it log 1:01:23, for hours:minutes:seconds, etc. as it works for example in premiere or after effects when typing numbers in the timecode field.
That kind of auto-formating for timecode, with various framerates presets, would be wonderful!!

Will a formula solution suffice in the meantime? It just processes the raw text, but it might still save you some time.

IF(
    {Timecode Raw},
    REGEX_REPLACE(
        {Timecode Raw},
        REPT("(\\d{2})", (ROUND((LEN({Timecode Raw})) / 2)) - 1) & "$",
        LEFT(":$1:$2:$3", 3 * ((ROUND((LEN({Timecode Raw})) / 2)) - 1))
    )
)

With the help of an automation that runs a script, it’s possible to translate this into inline formatting. Normally automations that act on data changes don’t wait for the user to finish editing a field, but I’ve come up with a method that actually waits.

I came up with this wait-for-the-user-to-finish-editing setup a couple of months ago, but haven’t had the time yet to document and share it. I’ll probably put some time into it over the holiday break and post a new thread.