<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" width="40px" /> This example database shows both the current time (using the now function), as well as the current time rounded to the nearest hour.

Created by Thomas Frank | Learn Notion Formulas | Notion Basics | Templates | Twitter

</aside>

Round Current Time to Nearest Hour

// Compressed
if(minute(now()) < 30, dateSubtract(now(), minute(now()), "minutes"), dateAdd(now(), 60 - minute(now()), "minutes"))

// Expanded
if(
    minute(
        now()
    ) < 30,
    dateSubtract(
        now(),
        minute(
            now()
        ),
        "minutes"
    ),
    dateAdd(
        now(),
        60 - minute(
            now()
        ),
        "minutes"
    )
)

© Thomas Frank