Add minutes to current time

AppSheet AppSheet Q&A
1

Any ideas how I could add minutes to the current time?

TIMENOW()+30 adds thirty HOURS and I need to add MINUTES…

2

@Michael
Can you try with
TIMENOW() + “00:30:00” OR TIMENOW() + (30/60)

3

See examples here.

4

LeventK:

TIMENOW() + “00:30:00”

Arithmetic expression '(TIMENOW()+"12/30/1899 12:30:00 AM")' has inputs of an invalid type 'Unknown'

LeventK:

TIMENOW() + (30/60)

Doesn’t seem to add any time:

1X_5a5697c11cd5707cecb319d706071e8f5b788d76.png
1X_5a5697c11cd5707cecb319d706071e8f5b788d76.png479×247 7.91 KB

5

Man… I just wanna add 30 minutes!..

TIME(
CONCATENATE(
HOUR(TIME(NOW())-"00:00:00"),
":",
MINUTE(TIME(NOW())-"00:00:00")+30,
":",
SECOND(TIME(NOW())-"00:00:00")
 )
 )
6

@Michael

Can you try with:

TIMENOW() + "000:30:00"

Levent KULACOGLU
ABLE3 Ventures, LLC
Managing Partner

7 
There is a problem when the time ends at :30 minutes, 
for example "07:30:00" + "30" 
results in "7:60" and not "8:00:00"

jtoroher_0-1684278626929.png
jtoroher_0-1684278626929.png956×615 35.6 KB
8

For anyone else looking for a solution all the documentation appears to be wrong and suggests you add the time in the wrong format, the format should be

  • “000:30:00”

Note you use the quotes and three numbers for the hours, not just two as most of the documentation suggests.

9

solved my problem with time addition, thanks @StephenHind