Power Query
published
Search
⌃K

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.
Time.FromText("10:12:31am")

time(10, 12, 31)

Convert "1012" into a Time value.
Time.FromText("1012")

time(10, 12, 00)

Convert "10" into a Time value.
Time.FromText("10")

time(10, 00, 00)

Last modified 4yr ago