Round up timestamp to second

Wed, 15 May 2013 14:47:58 GMT

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

Re: Round up timestamp to second

Gysbert_Wassenaar — Wed, 15 May 2013 14:51:10 GMT

Try round([duration], 1/86400)