Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Time.From
Time.FromText
Time.Hour
Time.Minute
Time.Second
Time.ToRecord
Time.ToText
Type
Uri
Values
Powered By GitBook
Time.ToText

Time.ToText

Returns a textual representation of the Time value.
function (optional time as nullable any, optional format as nullable any, optional culture as nullable any) as nullable any

Description

Returns a textual representation of time, the Time value, time. This function takes in an optional format parameter format. For a complete list of supported formats, please refer to the Library specification document.

Category

Time

Examples

Get a textual representation of #time(11, 56, 2).
1
Time.ToText(#time(11, 56, 2))
Copied!
"11:56 AM"
Get a textual representation of #time(11, 56, 2) with format option.
1
Time.ToText(#time(11, 56, 2), "hh:mm")
Copied!
"11:56"
Previous
Time.ToRecord
Next
Type
Last modified 3yr ago
Copy link
Contents
Time.ToText
Description
Category
Examples