Any ideas how I could add minutes to the current time?
TIMENOW()+30 adds thirty HOURS and I need to add MINUTES…
@Michael
Can you try with
TIMENOW() + “00:30:00” OR TIMENOW() + (30/60)
See examples here.
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:
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")
)
)
2 Likes
Can you try with:
TIMENOW() + "000:30:00"
Levent KULACOGLU
ABLE3 Ventures, LLC
Managing Partner
1 Like
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"
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.
4 Likes
solved my problem with time addition, thanks @StephenHind