Add minutes to current time

[Michael2]

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

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

[LeventK]

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

[Michael2]

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:

[Steve]

See examples here.

[Michael2 · Accepted solution]

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")
 )
 )

[LeventK]

@Michael

Can you try with:

TIMENOW() + "000:30:00"

Levent KULACOGLU
ABLE3 Ventures, LLC
Managing Partner

[jtoroher]

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"

[StephenHind]

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.

[kdw]

solved my problem with time addition, thanks @StephenHind