Source column format: MM:SS e.g. 01:30 -> 90 seconds.
convertx
{
"field": "name_of_column",
"expression": "str({name_of_column}).split(' ')[0]"
}
convertx
{
"field": "name_of_column",
"expression": "int({name_of_column}[:2]) * 60 + int({name_of_column}[3:5])"
}
RESULT
| Input | |
| 01:30 |
| Output |
| 90 |
Comments
0 comments
Please sign in to leave a comment.