I know how the Notion formula works. But when the date is the same and the time is different, this formula seems to not work properly. So what’s the right way to calculate this in Notion?
Connect
1 Answer
If you want to count time rather than date in Notion, you should use the timestamp formula. The output of datebetween formula is "days", and minor data will be ignored. While the unit of the timestamp formula output is millisecond. 1000 millisecond = 1 second, it should be easier to transform it into any unit you want.
Hope that helps.
Without Answer
-
- 468
- 0
- Apr 29
-
- 428
- 1
- Mar 20
-
- 428
- 0
- Mar 14
-
- 380
- 0
- Feb 21
-
- 359
- 1
- Feb 14
-
- 436
- 0
- Feb 13
-
- 460
- 0
- Feb 11
-
- 418
- 1
- Feb 8
- see all
Recent Activities
amandabee answered 3 hours ago
Counting Stars?polle answered 1 day ago
Counting Stars?amandabee answered 1 day ago
settings of font colour changed?amandabee asked 1 day ago
Counting Stars?joeythelemur commented Apr 29
How can I better organize a LOT of properties?
...