Scripts: Convert minutes/seconds into seconds

Clara Kantner

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

0 comments

Article is closed for comments.