#time

Syntax

#time(hour as number, minute as number, second as number) as time

Description

Creates a time value from whole numbers hour hour, minute minute, and (fractional) second second. Raises an error if these are not true:

0 ≤ hour ≤ 24
0 ≤ minute ≤ 59
0 ≤ second ≤ 59
if hour is 24, then minute and second must be 0

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / Time Functions / #time