Time#

- script and chart function

Time#() evaluates an expression as a time value, in the time format set in the data load script or the operating system, unless a format string is supplied..

Syntax:

time#(text[, format])

Return data type: dual

Arguments:

Argument	Description
text	The text string to be evaluated.
format	String describing the format of the text string to be evaluated. If omitted, the short date format, time format, and decimal separator set in the operating system is used. See: Conventions for number and time formats

Argument

Description

text

The text string to be evaluated.

format

String describing the format of the text string to be evaluated. If omitted, the short date format, time format, and decimal separator set in the operating system is used.

See: Conventions for number and time formats

The examples below assume the two following operating system settings:

Time format default setting 1: hh:mm:ss
Time format default setting 2: hh.mm.ss

Example	Results	Setting 1	Setting 2
time#( A ) where A=09:00:00	String:	09:00:00	09:00:00
time#( A ) where A=09:00:00	Number:	0.375	-
time#( A, 'hh.mm' ) where A=09.00	String:	09.00	09.00
time#( A, 'hh.mm' ) where A=09.00	Number:	0.375	0.375

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here