HH:MM:SS to Minutes

Entries

Duration

Type

Hours

Minutes

Seconds

Total Min

⠀

9:42

M:S

NaN

10:30

M:S

NaN

1:47:16

H:M:S

107.27

0:05

M:S

NaN

M:S

NaN

a:05

Invalid

NaN

10:a

Invalid

NaN

1:2:a

Invalid

NaN

6:46

M:S

NaN

Total Min


if(test(prop("Duration"), "[a-z]") or length(replaceAll(prop("Duration"), "[^:]", "")) == 0, toNumber(""), if(length(replaceAll(prop("Duration"), "[^:]", "")) == 2, toNumber(prop("Duration")) * 60, toNumber("")) + if(length(replaceAll(prop("Duration"), "[^:]", "")) == 1, toNumber(prop("Duration")), toNumber(replace(prop("Duration"), "^[^:]*:", ""))) + round(toNumber(replace(replace(prop("Duration"), "^[^:]*:", ""), "^[^:]*:", "")) / 60 * 100) / 100)

Hours


if(length(replaceAll(prop("Duration"), "[^:]", "")) == 2, toNumber(prop("Duration")), toNumber(""))

Minutes


if(length(replaceAll(prop("Duration"), "[^:]", "")) == 1, toNumber(prop("Duration")), toNumber(replace(prop("Duration"), "^[^:]*:", "")))

Seconds


toNumber(replace(replace(prop("Duration"), "^[^:]*:", ""), "^[^:]*:", ""))

00:00 to Hrs/Mins

Entries

Duration

##:## to Hrs/Mins

⠀

6:46

6.77

9:42

9.7

10:30

10.5

0:05

0.08

NaN

1:47:16

NaN

a:05

NaN

10:a

NaN

1:2:a

NaN

00:00 to Hrs/Mins


if(length(replaceAll(prop("Duration"), "[^:]", "")) > 1, toNumber(""), if(length(replaceAll(prop("Duration"), "[^:]", "")) == 0, toNumber(prop("Duration")), toNumber(prop("Duration")) + round(toNumber(replace(replace(prop("Duration"), "^[^:]*:", ""), "^[^:]*:", "")) / 60 * 100) / 100))

Time

Minutes

Seconds

Duration

⠀

1:05

1.08

0:05

0.08

1:10

1.17

1:59

1.98

10:30

10.5

10:05

10.08

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!