TIME

TIME Converts hours, minutes, and seconds given as numbers to a time in datetime format.


Syntax

TIME(hour, minute, second)

Parameters

hour – A number from 0 to 23 representing the hour.

Any value greater than 23 will be divided by 24 and the remainder will be treated as the hour value.
minute – A number from 0 to 59 representing the minute.

Any value greater than 59 will be converted to hours and minutes.

second – A number from 0 to 59 representing the second.

Any value greater than 59 will be converted to hours, minutes, and seconds.

Return Value

A time (datetime).


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Date and Time Functions / TIME