If you haven't set the correct standard time format, your field is probably not correctly interpreted, try
time(round([Metrics Time],maketime(0,30))) as RoundedMetricsTime;
time#([Metrics Time],'hh.mm.ss') as [Metrics Time]
If you are coping with intervals rather than time values (i.e. values can exceed 24h), use the interval#() / interval() functions.
Hope this helps,
I guess im kind of confused as to where im putting all this...
You'd think I would have gotten it by now.
Sample time.png 5.4 K
If above is your general format you want to use as time format, use
at the top of your script. If so, I would recommend to use the standard format.
If you interpret a time format using time#() function, this will only affect the field you are applying this function to ([Metrics Time2] in your example). So if you use TIME again in the calculation for the rounded value, the format is not interpreted with the 'special' format code. You can do a preceding load like I've shown above or just embed the format interpretation into the round:
time(round( time#([Time],'hh.mm.ss'),maketime(0,30))) as RoundedMetricsTime;
to round the time is also very important to show the correct interval value in the format hh:mm:ss. I've had the problem, that QV shows the floor-value of an interval.
0,00024722223 = 00:05:00
0,00024722221 should be rounded to 00:05:00, but QV shows 00:04:59
By using the expression round(value,maketime(0,0,1)), QV rounds the value to the nearest full second. In my example it is 00:05:00.