Hi guys, I am building an app, where I take the current date/time as an input in a form. I use that as the start date/time and then need to add the minutes they have bought as a coupon to make the end time. From there I need to calculate how much time is left in their coupon. So for example, they b…

Hi gurpal, You can use the start time to which you add 30 minutes to have your end time. You can use NOW() to get the time at present. You can use MINUTE() to make a substraction. Check out: [image] Calculating time in Google Sheets: subtract, sum and extract date and time units It's…

Hi Karim, thanks for the article. I have tried it, but the way that Glide sends the data/time to google sheet is yyyy-mm-ddTHH:mm:ssz I tried adding the time, but it did not work. Anything I may be missing?

You have to create a separate column where you apply a TEXT() formula to the data that Glide sends. This way you will get it in the format that you need https://support.google.com/docs/answer/3094139?hl=en

@Karim , you my dear friend, have helped me solve a problem that I was stuck on for quite a while. Thank you, kind sir.

Hi, I’m having some problems with time calculations. I’m creating and app where they sign in and submit how many weeks old their puppy is. Then I automatically want their profile to change and add one more week to the age each week that passes. The week of the puppy will change what content they wi…

If you can have the pup’s birthday on the initial registration then you can do the calculation in the Sheets to return the number of weeks as you want.

Yeah, I did that but whenever a new user joins I have to add the formula e.g. it doesn’t automatically update since it’s in google sheet rather than the editor. Or maybe this can be solved in sheets? :thinking:

[image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s …

Create countdown based on time submitted

Ask for Help

Jeff_Hager July 9, 2020, 10:46pm 9

Topic		Replies	Views
Timer functionality Ask for Help	9	1594	June 9, 2020
Help with time duration equation between two dates/times Ask for Help	9	2522	July 21, 2020
Google sheets takes time to update! Ask for Help	10	275	April 26, 2024
How to create, just, the time picker Ask for Help	5	546	September 21, 2021
Form Data Clearing Sheet Formatting & Not Updating Sheet Ask for Help	13	636	October 11, 2021

Create countdown based on time submitted

Related topics