< Day Day Up > |
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. |
< Day Day Up > |