Source column format: MM:SS (e.g. 01:30) -> 90 seconds.
convertx
{
"field": "Duration",
"expression": "str({Duration}).split(' ')[0]"
}
convertx
{
"field": "Duration",
"expression": "int({name_of_column}[:2]) * 60 + int({name_of_column}[3:5])"
}
EXAMPLE INPUT
Duration |
---|
01:30 |
EXAMPLE OUTPUT
Duration |
---|
90 |
Comments
0 comments
Article is closed for comments.