← Back to Time functions

Time.ToRecord

This function retrieves a data set that includes the components of a specified Time value. The input parameter, time.time, represents the specific time value for which the data set is to be generated.

Syntax

Time.ToRecord(time as time) as record

About

This function retrieves a data set that includes the components of a specified Time value. The input parameter, time.time, represents the specific time value for which the data set is to be generated.

Explanation

Transform the #time(11, 56, 2) numerical value into a set comprising Time values. Utilize Power Query MTime.ToRecord(#time(11, 56, 2)) to achieve this. The resulting output will display the Hour as 11, Minute as 56, and Second as 2.