Solved: Re: time format while exporting - Qlik Community

Report Inappropriate Content · ‎2016-09-22

Hi Experts,

i have an expression which calculates interval(expression) with the format hh:mm:ss

for example my value of that expression is 00:01:51

when i export to excel this value gets changed to 00:01:52

this is because of the millisecond in excel rounding to the next second (00:01:51.7 changed to 00:01:52)

is it possible to do this rounding in qlikview expression?

if so, can anyone please help me with the expression?

sunny_talwar · ‎2016-09-22

May be do something like this:

Interval(Round(expression, (1/(24*60*60))))

View solution in original post

Anonymous · ‎2016-09-22

Hi,

Have a look:

Hope it helps

miguelbraga · ‎2016-09-22

Check the help page of the function Round

Best regards,

D.A. MB

Report Inappropriate Content · ‎2016-09-22

can you please help with expression

miguelbraga · ‎2016-09-22

Check this post:

miguelbraga · ‎2016-09-22

I'll try to figure something out

sunny_talwar · ‎2016-09-22

May be do something like this:

Interval(Round(expression, (1/(24*60*60))))

Report Inappropriate Content · ‎2016-09-22

Thank you so much sunny