Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

I have a database with a text property called Time Spent. I need to convert the text to minutes.

Time Spent
2:12
00:20 | 1:45
1:34 & 2:34 & 3:00
00:45 - 1:11 - 1:33 - 00:12

So far, I can only convert the first row to minutes using this formula:

toNumber(prop("Time Spent")) * 60 + toNumber(replace(prop("Time Spent"), "[^ ]:", ""))
replaceAll(prop("Time Spent"), "[&|-]", "")

removes the strings/characters that I want between the hours:minutes but I'm still stuck on how to convert after removing those characters.

I really appreciate any help you can provide.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect