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.FromText
Time.FromText
Creates a Time from local and universal Time formats.
function (optional
text
as nullable any, optional
culture
as nullable any) as nullable any
Description
Creates a
time
value from a textual representation,
text
, following ISO 8601 format standard.
Category
Time
Examples
Convert
"10:12:31am"
into a Time value.
1
Time.FromText("10:12:31am")
Copied!
time(10, 12, 31)
Convert
"1012"
into a Time value.
1
Time.FromText("1012")
Copied!
time(10, 12, 00)
Convert
"10"
into a Time value.
1
Time.FromText("10")
Copied!
time(10, 00, 00)
Previous
Time.From
Next
Time.Hour
Copy link
Contents
Time.FromText
Description
Category
Examples