Power Query
Search…
Time.StartOfHour

Time.StartOfHour

Returns the first value of the hour.
function (optional dateTime as nullable any) as nullable any

Description

Returns the first value of the hour given a time, datetime or datetimezone type.

Category

Date

Examples

Find the start of the hour for October 10th, 2011, 8:10:32AM (#datetime(2011, 10, 10, 8, 10, 32)).
1
Time.StartOfHour(#datetime(2011, 10, 10, 8, 10, 32))
Copied!

datetime(2011, 10, 10, 8, 0, 0)