Power Query
Search…
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)