How to convert 4400 sec into hours and minutes
Connect
1 Answer
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.
Related questions
- convert text property to minutes and split values before and after each character
- calculate minutes from date property with beginning and end time
- How to calculate a result number based on selected tags from multi select property?
- How can I calculate minutes to add total hours (or minutes) in a formula to add totals?
- Is it possible to set "End date" and "Include time" toggled by default for a date property?
Without Answer
-
- 116
- 0
- Oct 3
-
- 301
- 0
- Aug 12
-
- 348
- 0
- Aug 7
-
- 457
- 0
- Jul 17
-
- 1533
- 0
- Apr 14
-
- 1048
- 0
- Apr 10
-
- 1067
- 0
- Apr 7
-
- 1018
- 0
- Apr 6
- see all
Recent Activities
freelancerops answered 7 hours ago
How can I update a related page when an action is …freelancerops answered 7 hours ago
Looking to create a proposal w/lists that automati…freelancerops answered 7 hours ago
How can I calculate minutes to add total hours (or…freelancerops answered 10 hours ago
How Can I Use Notion to Organize a Busy Work Workf…freelancerops answered 10 hours ago
How can I filter rollups to show only the most rec…
...

