Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
i met an problem , i m trying to round some durations to the second up.
their format are like that hh:mm:ss,fff .
i would like to round up to the second if the tenth of a second is superior than 5...
For example, for an duration as 00:04:52,233 => 00:04:52
00:04:51,755=> 00:04:52
I ve tried to this formular but it doesn't work
time(round( time#([duration],'hh.mm.ss'),maketime(0,0,1))) as duration,
if somebody could help me....
thanks
Pierre
Try round([duration], 1/86400)