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?
Turning a raw amount of seconds into timecode
+2
+7Yes, I can provide a formula solution to convert a total number of seconds into a duration format (hours:minutes: seconds.milliseconds)
+31Yeap 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
Adam, Airtable Consultant - thetimesaving.company
+2Yeap 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
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.
+31Thanks! 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.
Ah, check out this guide for how to duplicate a base: https://support.airtable.com/docs/creating-a-new-empty-base#duplicating-airtable-bases
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.