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



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


polle Points79930

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"


nosy commented

Thank you, that worked!

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!