Turning a raw amount of seconds into timecode

[Alexm01]

I am looking to take a field that has a total amount of seconds and have it formulate into a duration.

E.g. My "seconds" field set as 210 would populate in my formula field as 00:03:30:000.

Does anyone have a formula solution for this?

[Ade345]

Yes, I can provide a formula solution to convert a total number of seconds into a duration format (hours:minutes: seconds.milliseconds) 

[TheTimeSavingCo]

Yeap check out this base.  Once you duplicate it to your own workspace you'll be able to use all the formulas and I set it up as one field each so that it's clearer how it works 

[Alexm01]

Thanks! This is probably a stupid question, but how can I duplicate this view? I tried copy and pasting the cells, but the formulas do not convert over. I only have view permissions, so I cant see open the filed editor to see the formulas either. There is no option that I see for exporting.

[TheTimeSavingCo]

Ah, check out this guide for how to duplicate a base: https://support.airtable.com/docs/creating-a-new-empty-base#duplicating-airtable-bases