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	2456	July 21, 2020
Google sheets takes time to update! Ask for Help	10	226	April 26, 2024
How to create, just, the time picker Ask for Help	5	520	September 21, 2021
Form Data Clearing Sheet Formatting & Not Updating Sheet Ask for Help	13	613	October 11, 2021

Create countdown based on time submitted

Related topics