Time.EndOfHour Function in Power Query

The Time.EndOfHour function in Power Query returns the end of the hour.

Syntax

Time.EndOfHour(dateTime as any) as any

The parameter dateTime as any specifies the time value. It returns is a time value.

Example:

Power Query M

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

The output of the above code is 20:59:59.9999999.