Notion Answers

Get help from other 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

2votes

How to apply time formatting in Notion?

I have a table for tracking how much time I spent on reading every day. I want to record in minutes for calculating the sum, is it possible to change the format into something like 2h30m with formula?

Thanks in advance.

1 Answer

2votes

polle Points16300

The solution is to count the number of hours and minutes. You can do it with a formula and this example may help you.

format(floor(prop("time worked") / 60)) + "h" + format(prop("time worked") - floor(prop("time worked") / 60) * 60) + "m"

0vote

nosy commented

Thank you, that worked!

Please log in or register to answer this question.

Exclusive for Notion Answers Users

...

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