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
🆕 Date-time Math General data-editor	126	12108	September 27, 2023
Make a countdown Ask for Help	4	262	December 7, 2021
Countdown timer Ask for Help	9	1356	January 25, 2021
Help with a formula (likely going to be in Sheets) Ask for Help	39	1509	November 18, 2020
Create Countdown Ask for Help	8	246	January 17, 2022

Create countdown based on time submitted

Related Topics