# Time format and Arrayformula function
**URL:** https://community.glideapps.com/t/time-format-and-arrayformula-function/26602
**Category:** Ask for Help
**Created:** [May 10, 2021, 3:15pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602 "2021-05-10T15:15:28Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@julien\_roullier](https://community.glideapps.com/u/julien_roullier)
#### Post date: [May 10, 2021, 3:15pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/1 "2021-05-10T15:15:29Z")
Hello,
I am using array formula function in my spreadsheet to auto-fill calculations when glide users fill a form. One of the array formula function need to be in time format (ex: HH:MM:SS) but when a new line is created the time format disappear and becomes a simple number (ex : 1,299990).
Does someone can help me ?
Thank you
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 10, 2021, 3:22pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/2 "2021-05-10T15:22:36Z")
Can you show what your arrayformula looks like?
Also, I would ask the question do you actually need this time column in your spreadsheet?
If the data is only used in Glide, then you might find that it’s better to calculate this in Glide using date math.
---
### Author:  [@julien\_roullier](https://community.glideapps.com/u/julien_roullier)
#### Post date: [May 10, 2021, 3:35pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/3 "2021-05-10T15:35:28Z")
When I create a new row in the Glide data I have the same problem:
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [May 10, 2021, 6:51pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/4 "2021-05-10T18:51:15Z")
This is happening because you don’t have rows under, so glide is actually adding a new row which is not formatted by Google, add more rows to that sheet, and in array formula delete second “”
If(l2:l="", , l2:l - …
---
### Author:  [@julien\_roullier](https://community.glideapps.com/u/julien_roullier)
#### Post date: [May 10, 2021, 7:38pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/5 "2021-05-10T19:38:00Z")
If I have 100 rows under formatted by Google, Glide will create a new one after the 100 and the new one will not die formatted
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [May 10, 2021, 7:44pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/6 "2021-05-10T19:44:11Z")
Add 1000 or more
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [May 10, 2021, 7:45pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/7 "2021-05-10T19:45:17Z")
If you erase “” from arrayformula, glide will add to next empty row
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [May 10, 2021, 7:46pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/8 "2021-05-10T19:46:17Z")
You need to change all your arrayformulas.
You are writing “” to cell’s that’s why glide considering those rows not empty and adding unformated new row.
Change your arrayformulas, and erase manually all empty rows (not delete… erase)
And always use this way to check empty rows:
=ARRAYFORMULA(IF(A2:A="", , B2:B - C2:C))
---
### Author:  [@julien\_roullier](https://community.glideapps.com/u/julien_roullier)
#### Post date: [May 10, 2021, 8:31pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/9 "2021-05-10T20:31:31Z")
If I add 1000rows Glide create a row after these 1000.
With or without 33 glide create a new row with the array formula function
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [May 10, 2021, 8:32pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/10 "2021-05-10T20:32:26Z")
Erase all empty rows…
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [May 10, 2021, 8:46pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/11 "2021-05-10T20:46:38Z")
You need to find and change all arrayformulas in this sheet
The reason why Glide is adding a row after 1000 rows is because they are not empty, your arrayformulas writing “” to these rows… fix all formulas in this sheet the way i show you (not only one formula, all of them)
---
### Author:  [@julien\_roullier](https://community.glideapps.com/u/julien_roullier)
#### Post date: [May 10, 2021, 9:09pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/12 "2021-05-10T21:09:57Z")
I do exactly what you said: erase empty row by changing “” by ;; on all array formula. I add 500 rows.
But it doesn’t work ☹
---
### Author:  [@julien\_roullier](https://community.glideapps.com/u/julien_roullier)
#### Post date: [May 10, 2021, 9:16pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/13 "2021-05-10T21:16:09Z")
By the way I find a solution but it’s not easy.
I create a new sheet and I enter “=arrayformula(‘Parcours en Etoile’!M:M)”. On this sheet I change the format to time format.
Then on the first sheet I add a new column and I enter a new array formula to copy the second sheet. 😀
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [May 10, 2021, 9:19pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/14 "2021-05-10T21:19:40Z")
Why you using ; ?
Use ,
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [May 10, 2021, 9:24pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/15 "2021-05-10T21:24:54Z")
If is not working, you missed some formulas, and is still populating data
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [May 10, 2021, 9:36pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/16 "2021-05-10T21:36:16Z")
Or you have some filter or query formula there that is filling down columns with empty values
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 10, 2021, 10:17pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/17 "2021-05-10T22:17:23Z")
Other countries use ‘;’ in place of ‘,’ and vice versa.
---
### Author:  [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)
#### Post date: [July 26, 2022, 11:48am UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/18 "2022-07-26T11:48:13Z")
Guys need your advise please How to create a formal on single row sheet need to copy the single row on glide when action happened without any triggers would be appreciate if anyone get back to me ASAP as this am urgent I’m happy to pay for the service Thanks in advanced-))
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [July 26, 2022, 12:04pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/19 "2022-07-26T12:04:57Z")
can you provide more details? we can do Zoom if you wanna show me your screen
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/time-format-and-arrayformula-function/26602/20 "2024-01-17T16:49:27Z")