Time.StartOfHour Function in Power Query

The Time.StartOfHour function in Power Query is used to round down a time value to the start of the hour, effectively setting minutes and seconds to zero.

Syntax

The parameter datetime as any specifies the time value. It returns is a time value with minutes and seconds reset to 00:00.

Example:

Power Query M

let
    Source = Time.StartOfHour(#time(20, 54, 25))
in
    Source   

The output of the above code is 20:00:00.