# Time/Timer Vision Data Access functions

This topic lists the Vision Data Access functions that report execution cell times, read date and time from an internal clock, and trigger an event after a specified interval or at specified times.

Note: All returned values are from a referenced function Functions are tools that are available in Spreadsheet for processing and analyzing acquisitions or other results. You can add functions to your Spreadsheet job to create tool chains and produce results for specific applications. or cell.

Function | Description
--- | ---
GetAllTime(Image) | Returns the time in milliseconds from the start of an image acquisition Acquisition is the process or result of the vision system acquiring a new image. to the end of a job A job is a user-configured program in In-Sight Spreadsheet consisting of functions and designed for specific applications. You can create and edit jobs using the In-Sight Spreadsheet interface, and load them on a vision system for deployment in a live environment. execution, or #ERR if the input value is invalid. Note: If the vision system is offline, the returned value is higher than when the vision system is online.
GetElapsedTime(Image) | Returns the time, in milliseconds, between the last two image acquisitions.
GetExposureTimestamp(Image) | Returns the exposure timestamp of the start of an image exposure. Returns a Time structure.
GetTime(Cell1, [Cell2, ...]) | Returns the time in milliseconds for a variable-length list of cells to execute or #ERR if the input value is invalid. If multiple cells are selected, the sum of all execution times is returned.

To use GetAllTime:

1. Insert GetAllTime(A0) to a cell.

2. Trigger the In-Sight vision system.

   Note: The GetAllTime function calculates the time based on the last image acquisition. The return value of the function can be large at first. Make sure to trigger the vision system to get the correct value.
3. The time is returned to the cell.

Note:

- This argument must reference the cell A0, containing the Image data structure returned by the AcquireImage function.
- You cannot use this function in a formula. For example, if you enter "GetAllTime(A0)+10" in a cell, #ERR is returned. To use a formula, create a separate cell just for GetAllTime(A0), and use a cell reference for it in the formula. For example, you can configure the spreadsheet as follows:
  - B2 = GetAllTime(A0)
  - B3 = B2+10