Share this topic
LinkedIn
Twitter
Copy URL
Any ideas how I could add minutes to the current time?
TIMENOW()+30 adds thirty HOURS and I need to add MINUTES…
Solved! Go to 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") ) )
View solution in original post
never-displayed
LinkedIn
Twitter
