PT..M..S duration field import from other source

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

What do you need help with?

I was wondering if I could have a timestamp duration formatted with PT from an external source created in Baserow’s duration field. So far I’ve failed.

I get values from Clockify and Youtube such as:
PT7M19S
PT42M9S
PT28M47S

I can find my ways to get the numbers out with some complex formulas, but still as far as I know a formula field can’t represent a duration unless I’m mistaken.

Hey @360Creators

There is no direct way to convert your value into duration but using formula system you can convert it into seconds and then if you use formula like (assuming Seconds holds string with number of seconds from your formula):

toduration(tonumber(field('Seconds')))

You will have access to duration field settings (the same as duration field has)

1 Like

Yess!! That’s what I was looking for. I can calculate the hours, minutes and seconds into a single seconds field and use that. Awesome, thank you very much!! :grin: