# Stripe Checkout - App:Sales - Paid at - Timezone UTC?

**URL:** <https://community.glideapps.com/t/stripe-checkout-app-sales-paid-at-timezone-utc/6355>\
**Category:** Ask for Help\
**Created:** [April 3, 2020, 6:47am UTC](https://community.glideapps.com/t/stripe-checkout-app-sales-paid-at-timezone-utc/6355 "2020-04-03T06:47:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Burger\_Box](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/burger_box/32/5101_2.png) [@Burger\_Box](https://community.glideapps.com/u/Burger_Box)\
**Post date:** [April 3, 2020, 6:47am UTC](https://community.glideapps.com/t/stripe-checkout-app-sales-paid-at-timezone-utc/6355/1 "2020-04-03T06:47:39Z")

</div>

Hello Gliders,

After setting up Stripe Checkout, the completed orders that go into App:Sales spreadsheet have a field Paid at, which puts a timestamp on when the order was made. This time is currently UTC, do you know of any ways to change this to my timezone?

Got in touch with Stripe, but they were unable to help as this is more technical than the support can handle.

Any help here please?

---

<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:** [April 3, 2020, 11:59am UTC](https://community.glideapps.com/t/stripe-checkout-app-sales-paid-at-timezone-utc/6355/2 "2020-04-03T11:59:44Z")

</div>

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.

> <https://stackoverflow.com/questions/48679125/convert-utc-to-cst-time-zone-in-google-spreadsheet>

---

<div class="post-metadata">

**Author:** ![Burger\_Box](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/burger_box/32/5101_2.png) [@Burger\_Box](https://community.glideapps.com/u/Burger_Box)\
**Post date:** [April 4, 2020, 7:34am UTC](https://community.glideapps.com/t/stripe-checkout-app-sales-paid-at-timezone-utc/6355/3 "2020-04-04T07:34:09Z")

</div>

Tried to do this already,

but every new order that comes in, sees the new column’s (with formulas) rows as already taken and instead creates new rows at the bottom of the spreadsheet, essentially just skipping the rows that contain formulas.

Anything else please?

---

<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:** [April 4, 2020, 7:53am UTC](https://community.glideapps.com/t/stripe-checkout-app-sales-paid-at-timezone-utc/6355/4 "2020-04-04T07:53:30Z")

</div>

Are you using an arrayformula and deleting all of the empty rows? You can’t put a formula in each row for the reason you are experiencing. You should only need to create a formula once with the arrayformula, but you need to delete the empty rows because arrayformulas make all rows appear as populated. When a new row is added, the formula is automatically applied.

---

<div class="post-metadata">

**Author:** ![Burger\_Box](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/burger_box/32/5101_2.png) [@Burger\_Box](https://community.glideapps.com/u/Burger_Box)\
**Post date:** [April 4, 2020, 8:25am UTC](https://community.glideapps.com/t/stripe-checkout-app-sales-paid-at-timezone-utc/6355/5 "2020-04-04T08:25:28Z")

</div>

Right, thank you very much! 🙂

Think this is it!