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!! 