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.