GetAsTime()

GetAsTime()

Category: Text

Syntax: GetAsTime ( text )

Parameters: text ”any text expression or text field containing a time.

Description: GetAsTime() returns the data specified in the text string as data-type time. The value can then be manipulated like any other time data.

Examples:

 GetAsTime ("01:30:30") 

Returns 1:30:30 AM when you specify Time as the calculation result.

 GetAsTime ("01:30:30") 

Returns 1/1/0001 1:30:30 AM when you specify Timestamp as the calculation result.

 GetAsTime (48000) 

Returns 8:53:20 .

Use GetAsTime() when working with literal time strings in calculation formulas:

 GetAsTime ("15:30:00") - FinishTime 

would yield the elapsed time between 3:30pm and the FinishTime .

Comments:

GetAsTime() can be used to convert an integer representing a number of seconds into an elapsed time, as demonstrated in the third of the preceding examples.