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
-
- 457
- 0
- Apr 14
-
- 368
- 0
- Apr 12
-
- 503
- 0
- Apr 11
-
- 309
- 0
- Apr 10
-
- 309
- 0
- Apr 7
-
- 308
- 0
- Apr 6
-
- 302
- 0
- Apr 4
-
- 293
- 0
- Apr 3
- see all
Recent Activities
notionbackups answered May 22
How to print or export note or page as pdf with fi…notionbackups answered May 22
How to fix messed up decimal numbers after import …pjbdr026 asked Apr 14
How do teams use Notion for collaboration?pjbdr026 asked Apr 12
CRM System in Notionpjbdr026 asked Apr 11
Dashboard Setup
...

