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

How to convert secs into hours and minutes

How to convert 4400 sec into hours and minutes

1 Answer

0vote

polle Points94150

Use the following Notion formula to convert seconds to hours and minutes.

prop("Seconds") ? (format(floor(mod(prop("Seconds") / 86400, 1) * 24)) + " h " + " " + format(floor(mod(prop("Seconds") / 3600, 1) * 60)) + " min") : ""

This is using the name "Seconds" for the property where you have the seconds, so just rename it to what you are using in that column.

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