GetAsTime()
Category: Text
|
Syntax: GetAsTime ( text ) |
Parameters:
textAny text expression or text field containing a time.
Data type returned: 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.
GetAsTime() can be used to convert an integer representing a number of seconds into an elapsed time, as demonstrated in the third of the following examples.
Examples:
|
Function |
Results |
|---|---|
|
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. |
Using GetAsTime() when working with literal time strings in calculation formulas
GetAsTime ("15:30:00") - FinishTime
would yield the elapsed time between 3:30 p.m. and the FinishTime.