Round up timestamp to second

[#1]

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

[Gysbert_Wassenaar]

Try round([duration], 1/86400)