Skip to main content
All CollectionsViz FlowicsSettings
Time support for Google Sheets Provider
Time support for Google Sheets Provider
Updated over a week ago

Google Sheets data Provider supports the time inserted in a cell. With this support, you can integrate the time in the graphics you build with Flowics through this provider.

The function TIME allows you to converts an hour, minute, and second into a time.

If the data is not formatted it will be taken as a string (text) so you won't be able to show the TIME as it is in the sheet.

When is this format useful? When we need Flowics to recognize the data as the TIME. Some examples:

  • You want to use the TIME to filter, limit, or order the content.

  • You want to use the TIME for conditional display.

  • You want to convert the TIME format to another format in Flowics

Syntax

TIME(hour, minute, second)

  • hour - The hour component of the time.

  • minute - The minute component of the time.

  • second - The second component of the time.

Sample Usage

=TIME(11,40,59)

Result 11:40:59

Notes

  • Inputs to TIME must be numbers - if a string is provided, the #VALUE! error will be returned.

  • TIME will silently recalculate numeric time values that fall outside of valid ranges. For example, TIME(25,0,0), which specifies the illegal hour 25, will create a time of 1:00 AM. Similarly, TIME(12,0,60), which specifies the illegal 61st second of a minute (:00 being the first second), will create a time of 12:01:00.

  • TIME will silently truncate decimal values input into the function, e.g. an hour of 12.75 will be interpreted as 12.

Reference a cell

This is another format we support. With the function =TIME, you can reference the value of each parameter (hour, minute, second) from a cell. See the image below

Did this answer your question?