Add minutes to current time

expressions
(Michael) #1

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

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

(Levent Kulacoglu) #2

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

(Steve Coile) #3

See examples here.

(Michael) #4

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

Doesn’t seem to add any time:
Time

(Michael) #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")
 )
 )
(Levent Kulacoglu) #6

@Michael

Can you try with:

TIMENOW() + "000:30:00"

Levent KULACOGLU
ABLE3 Ventures, LLC
Managing Partner