Time

While perhaps not as frequently used in reporting as much as dates, time can also be an important reporting element, particularly when reporting on metrics such as employee performance or supply chain productivity.

Similar to dates, time is also represented in numeric form as fractions of a day. To observe this, create a new query with:

let
    Source = List.Generate(() => 0, each _ <= 24, each _ + 1),
    Table = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    AddMultiplicationColumn = Table.AddColumn(Table, "Multiplication", each [Column1] / 24, type number),
    DuplicateColumn = Table.DuplicateColumn(AddMultiplicationColumn, "Multiplication", "Multiplication - Copy"),
    ChangeType = Table.TransformColumnTypes(DuplicateColumn,{{"Multiplication - Copy", type time}}),
    RenameColumns = Table.RenameColumns(ChangeType,{{"Multiplication - Copy", "Time"}})
in
    RenameColumns...