Time.From(value as any, optional culture as nullable text) as nullable time


Returns a time value from the given value. An optional culture may also be provided (for example, "en-US"). If the given value is null, Time.From returns null. If the given value is time, value is returned. Values of the following types can be converted to a time value:

  • text: A time value from textual representation. Refer to Time.FromText for details.
  • datetime: The time component of the value.
  • datetimezone: The time component of the local datetime equivalent of value.
  • number: A time equivalent to the number of fractional days expressed by value. If value is negative or greater or equal to 1, an error is returned.

If value is of any other type, an error is returned.

Example 1

Convert 0.7575 to a time value.




#time(18, 10, 48)

Example 2

Convert #datetime(1899, 12, 30, 06, 45, 12) to a time value.


Time.From(#datetime(1899, 12, 30, 06, 45, 12))


#time(06, 45, 12)