# How to have the right time in the sheet App : Sales Stripe

**URL:** <https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630>\
**Category:** Ask for Help\
**Created:** [February 11, 2021, 6:43pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630 "2021-02-11T18:43:00Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\
**Post date:** [February 11, 2021, 6:43pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/1 "2021-02-11T18:43:00Z")

</div>

Hello 👋

I am sending this message since I need some help. I would like to have the right time in the App : Sales Stripe sheet. I tried to change the time zone in Stripe but I still have the same time. There is a gap of 1 hour between my time zone.

Is anyone has a solution to have the right time ?

Regards

---

<div class="post-metadata">

**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\
**Post date:** [February 11, 2021, 6:48pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/2 "2021-02-11T18:48:25Z")

</div>

Hey !

Thanks for raising your issue with the community. To help you find the best solution, I think that this post may be the one you’re looking for :

> [@Stripe Checkout - App:Sales - Paid at - Timezone UTC?](https://community.glideapps.com/t/stripe-checkout-app-sales-paid-at-timezone-utc/6355/2):
>
> Just do the math inside your spreadsheet to create a new column with the adjusted time. There’s plenty of info out there regarding this.

Hope this helps and let us know !

---

<div class="post-metadata">

**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\
**Post date:** [February 11, 2021, 7:05pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/3 "2021-02-11T19:05:04Z")

</div>

Thanks @AymenM for your quick reply ! Indeed, this link help a lot !  
However do you know where I may enter the formula ?

Regards

---

<div class="post-metadata">

**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\
**Post date:** [February 11, 2021, 7:07pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/4 "2021-02-11T19:07:13Z")

</div>

Hello back !

Happy to hear that you found a solution to your issue. You need to enter the most appropriate formula in your spreadsheet in the column where the time is not the same than your local one.

---

<div class="post-metadata">

**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\
**Post date:** [February 11, 2021, 8:03pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/5 "2021-02-11T20:03:37Z")

</div>

Hello again,

I tried to add the formula but I have an error, in attachment the error.

 ![Glide screen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/ee425ac2ebc3cb8c6cb0427a965f804d39d21216.png)

Could you please help ?

Regards

---

<div class="post-metadata">

**Author:** ![AymenM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aymenm/32/21370_2.png) [@AymenM](https://community.glideapps.com/u/AymenM)\
**Post date:** [February 11, 2021, 8:11pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/6 "2021-02-11T20:11:04Z")

</div>

Any advice on this @Jeff_Hager ?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 11, 2021, 8:12pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/7 "2021-02-11T20:12:50Z")

</div>

You don’t want to, and can’t for that matter, apply the formula into an existing column that’s already being filled by Glide. You will want to create a new column to perform the date math. I would also advise using an arrayformula, so you only need to apply the formula once on the first row, then delete all empty rows, so new rows aren’t added at the very bottom of the sheet.

Also, I know this is the case with the App:Logins sheet, so probably the same in the sales sheet, but the timestamp stored is in a string format instead of a date format, so you may need to convert it into a valid date before adding time to it.

---

<div class="post-metadata">

**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\
**Post date:** [February 11, 2021, 9:02pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/8 "2021-02-11T21:02:29Z")

</div>

Thanks @Jeff_Hager for this explanation.

However could you please tell me how may I convert it into a valid date before adding time to it ? And what is the content of arrayformula to be used ?

I am trying but I need some help to put this in place.

Regards

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 11, 2021, 10:05pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/9 "2021-02-11T22:05:15Z")

</div>

Can you try formatting the column as datetime value to see if it works?

---

<div class="post-metadata">

**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\
**Post date:** [February 12, 2021, 12:05am UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/10 "2021-02-12T00:05:21Z")

</div>

Hello,

I tried to formatting the column as datetime value and I was able to increase the time. Thanks !  
Now I am looking an solution for not displaying the empty fields. if anyone can help please ? In attachment a screenshot.

 ![Glide screen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aac891cb56f4f5e8d15ddb515a81f177709d3bb7.png)

Regards

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 12, 2021, 12:23am UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/11 "2021-02-12T00:23:42Z")

</div>

Put in your S1 cell.

```
={"Hour Time Zone";ARRAYFORMULA(IF(R2:R<>"";R2:R+TEMPS(1;0;0);""))}
```

---

<div class="post-metadata">

**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\
**Post date:** [February 12, 2021, 12:29am UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/12 "2021-02-12T00:29:17Z")

</div>

Thanks for your quick reply!  
Here the result. I have an error message. In attachment the screenshot.

 ![Glide screen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/4/3452a3a41a45d986ea31ab70957fd9a6e7bb4cd3.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 12, 2021, 12:36am UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/13 "2021-02-12T00:36:39Z")

</div>

Make sure you are putting @ThinhDinh’s formula in row 1 and you do not have anything else is rows 2+ for that column.

---

<div class="post-metadata">

**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\
**Post date:** [February 12, 2021, 12:50am UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/14 "2021-02-12T00:50:18Z")

</div>

Thanks for your supports. I make sure that the formula is well in row 1.  
I still have empty fields, may be I need to review formula in the column R. In attachment the formula.

 ![Glide screen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/b/1b3358bf8729f1c65d2c163660a752f466148967.png)

Could you please advise ?  
Regards,

---

<div class="post-metadata">

**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\
**Post date:** [February 12, 2021, 1:23am UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/15 "2021-02-12T01:23:39Z")

</div>

I put in my cells  
={“Name”;ARRAYFORMULA(IF(Cell [number]: Column \<\>"" …

But for Split formula, could you please tell me the correct syntax ? I have some errors.

=ARRAYFORMULA(SPLIT(SPLIT(P2:P5;".");"."))  
=ARRAYFORMULA(SPLIT(F2:F5;“T”))

Regards

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 12, 2021, 1:39am UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/16 "2021-02-12T01:39:26Z")

</div>

Can you give us a duplicate of that specific Sheet? Are there any specific reasons you want to have the “Hour to splitted”, “Hour splitted” and “Hour converted” columns?

---

<div class="post-metadata">

**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\
**Post date:** [February 12, 2021, 1:41pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/17 "2021-02-12T13:41:17Z")

</div>

Hello

I know it’s not the better solution to split by date and hour but I was trying to find a solution.  
Please find the specific Sheet.

> **[Duplicate](https://docs.google.com/spreadsheets/d/1VseLSCiRg0va03nqA6lsmx6-AhVyDzaByIDsnw_k9-g/edit?usp=sharing)**
>
> Feuille 1
> 
> Purchaser name,Purchaser email,Purchased item,Item SKU,Amount,Paid at,Date splited,Hour to splited,Hour splited,Hour converted,Hour Time Zone,Hour Time Zone Text
> TESTA,TEST PURCHASE: Pastel,2k5CVz0sTOamUW8..IBh.Q,TEST PURCHASE:...

I would need some help to finalize this.  
Please help

Regards,

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 12, 2021, 11:42pm UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/18 "2021-02-12T23:42:57Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/937f45aa797b9786c4320464e12fb5b063d0c07a.png)

Can you confirm this is what you want?

---

<div class="post-metadata">

**Author:** ![Galerie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/galerie/32/21375_2.png) [@Galerie](https://community.glideapps.com/u/Galerie)\
**Post date:** [February 13, 2021, 12:08am UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/19 "2021-02-13T00:08:50Z")

</div>

@ThinhDinh awesome it’s exactly what I want !  
Can you please share your formula ?

Regards

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 13, 2021, 1:59am UTC](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630/20 "2021-02-13T01:59:11Z")

</div>

It’s in the sheet in cell G1.

[Next page](https://community.glideapps.com/t/how-to-have-the-right-time-in-the-sheet-app-sales-stripe/22630.md?page=2)