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…

Create countdown based on time submitted

Ask for Help

Jeff_Hager July 9, 2020, 10:46pm 9

2 Likes

Topic		Replies	Views
Timer functionality Ask for Help	9	1559	June 9, 2020
Help with time duration equation between two dates/times Ask for Help	9	2463	July 21, 2020
How to create, just, the time picker Ask for Help	5	522	September 21, 2021
Form Data Clearing Sheet Formatting & Not Updating Sheet Ask for Help	13	618	October 11, 2021
Help with a formula (likely going to be in Sheets) Ask for Help	39	1610	November 18, 2020

Create countdown based on time submitted

Related topics