Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Round up timestamp to second

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

1 Reply
Gysbert_Wassenaar

Try round([duration], 1/86400)


talk is cheap, supply exceeds demand