1vote

How to convert secs into hours and minutes

How to convert 4400 sec into hours and minutes

1 Answer

0vote

polle Points102080

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