Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Duration.Days
Duration.From
Duration.FromText
Duration.Hours
Duration.Minutes
Duration.Seconds
Duration.ToRecord
Duration.TotalDays
Duration.TotalHours
Duration.TotalMinutes
Duration.TotalSeconds
Duration.ToText
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
Duration.ToRecord

Duration.ToRecord

Returns a record containing the parts of the duration.
function (duration as duration) as record

Description

Returns a record containing the parts the duration value, duration.

Category

Duration

Examples

Convert #duration(2, 5, 55, 20) into a record of its parts including days, hours, minutes and seconds if applicable.
1
Duration.ToRecord(#duration(2, 5, 55, 20))
Copied!
[Days = 2, Hours = 5, Minutes = 55, Seconds = 20]
Previous
Duration.Seconds
Next
Duration.TotalDays
Last modified 3yr ago
Copy link
Contents
Duration.ToRecord
Description
Category
Examples