If data is adding on row 1001, that means you didn’t delete the empty rows. You only have to do it once. Glide will add new rows and the formula will populate on those new rows.
Arrayformulas used to be the only way to do any kind on computation logic with glide, so I know it works, but that was more than 2 years ago and a lot has changed since then. As @Darren_Murphy said, doing it in glide is much better and faster, but if you absolutely need it to be in the google sheet then using arrayformulas and deleting empty rows is the proper way to do it.
Regardless if you use glide computed columns or arrayformulas in the google sheet, I would recommend using one of those methods instead of manually populating a set number of rows with a formula, or trying to set a formula by setting a column value in glide. It’s just going to be too much extra work and probably not reliable or scalable in the long term.
if there is a way to calculate the time duration of 2 dates using Glide or Hyperformula or Excel can you show me how?
I have also tried using Hyperformula on Glide but the results are less accurate than the Google Sheet formula.