Hi Team,
would be possible to use in an โinitial valueโ of time
next time oโclock() ?
ex:
if timenow() = 14:25
then next time oโclock = 15:00
thanks in advance and happy christmas days for all appsheeters.
Solved! Go to Solution.
Try:
("00:00:00" + HOUR(TIMENOW() - "00:00:00") + 1)
thks a lot Steve!!!
Hmm, CEILING wouldnโt work for time formats, eh? I should probably make a feature request that math functions like ROUND, CEILING, FLOOR, etc to be useable on TIME data types.
Just for purely academic purpose, thought of sharing another variation of the expression. The expression is totally inspired by and based on @Steveโs original excellent expression.
Dave also rightly suggested the use case of CEILING, FLOOR, ROUND etc. for direct use on Time data types, which will make Time math much easier. The expression below incidentally needs and indirectly uses CEILING and thus justifies Daveโs suggestion.
โ00:00:00โ+CEILING(TOTALHOURS(TIMENOW() - โ00:00:00โ))
Yes, and my upcoming feature request will be to use them directly. Since [Time]+[Number]
math works, and converts Number to be in hours by default. My feature request is basically that ROUND/CEILING/FLOOR([Time])
should automatically do their things to the nearest hour.
Also, in my opinion, TIME and DECIMAL should be compatible & convertible on the backend. TIME(5.5) should equal 05:30 or 5:30AM and DECIMAL(โ05:30โ) should equal 5.5. Because this change would because fix my top request by default and wouldnโt require a change to how those functionsโฆuhโฆfunction.
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |