Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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