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
Last modified 3yr ago
Copy link
Contents
Time.FromText
Description
Category
Examples