# GetAsTime

Returns times or timestamps in text as field type time.

`GetAsTime ( text )`

## Parameters

`text`

- any text expression or text field containing a time

## Data type returned

time

## Originated in version

6.0 or earlier

## Description

Use with formulas involving the Time or Timestamp function; use the GetAsTime or the Time function to enter a time constant into a formula. The format of the supplied time must be the same as the time format on the system where the file was created.

## Example 1

`GetAsTime ( "02:47:35" )`

returns **2:47:35** when you select time as the calculation result. You can perform time calculations on this result.

## Example 2

`GetAsTime ( "02:47:35" )`

returns **1/1/0001** **2:47:35** when you select timestamp as the calculation result.

## Example 3

`Abs (GetAsTime ( "12:15 pm" ) - CheckOut )`

returns **3:00:00** when the CheckOut time field contains 3:15 PM.

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas