Time.FromText

This function generates a time value based on a given textual representation. Additionally, an optional record parameter called "options" can be included to specify extra properties. The "options" record can include the following fields: - Format: A text value that specifies the desired format for the time representation. More information can be found at https://go.microsoft.com/fwlink/?linkid=2180104 and https://go.microsoft.com/fwlink/?linkid=2180105. If this field is omitted or set to null, the time will be parsed using a default method. - Culture: When the Format field is not null, the Culture field determines certain formatting specifications. For example, in the "en-US" culture, "tt" represents "AM" or "PM", while in the "ar-EG" culture, "tt" represents "ص" or "م". If the Format field is null, the Culture field defines the default format to use. If Culture is null or not provided, the default culture (Culture.Current) will be used. In order to accommodate older workflows, the "options" parameter c

Rephrase the following text with a technical tone including simple English for non-native speakers to understand without losing the technical description: Example 1: Convert the string "10:12:31am" into a Time value. Instructions: In Power Query M, use the function Time.FromText("10:12:31am"). Result: The output will be #time(10, 12, 31). Example 2: Convert the string "1012" into a Time value. Instructions: In Power Query M, use the function Time.FromText("1012"). Result: The output will be #time(10, 12, 00). Example 3: Convert the string "10" into a Time value. Instructions: In Power Query M, use the function Time.FromText("10"). Result: The output will be #time(10, 00, 00).