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
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.
TIMEmust be numbers - if a string is provided, the
#VALUE!error will be returned.
TIMEwill 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.
TIMEwill 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