Time.EndOfHour

This function retrieves the precise end of the hour from the dateTime input, including any fractional seconds. The time zone data associated with the input dateTime is maintained. Input: The input should be a time, dateTime, or dateTimezone value from which the end of the hour will be determined.

Retrieve the end time of the hour for May 14, 2011, at 5:00:00 PM using Power Query MTime.EndOfHour(#datetime(2011, 5, 14, 17, 0, 0)). The output will be #datetime(2011, 5, 14, 17, 59, 59.9999999). Retrieve the end time of the hour for May 17, 2011, at 5:00:00 PM with a time zone offset of -7:00 using Power Query MTime.EndOfHour(#datetimezone(2011, 5, 17, 5, 0, 0, -7, 0)). The output will be #datetimezone(2011, 5, 17, 5, 59, 59.9999999, -7, 0).