Convert Milliseconds to Seconds

[puneetagarwal]

Hi All,

We have a column in db where the values gets store in Milliseconds (Bigint), I need to covert the Milliseconds value into seconds in qlikview.

When we export the Data/Excel we should be able to perform Aggregate calculation (Sum,Avg) etc.

Sample Values:

TimeInMS	Time in Seconds
420000	420
2640000	2640
420000	420
120000	120
420000	420

Regards,

Puneet Agarwal

[Chanty4u]

try this

=round(Yourfield/1000)

[puneetagarwal]

Tried, when i export to excel im not able to perform calculation on this column.

That is my major concern.

[balabhaskarqlik]

=round(TimeinMS/1000) as [Time in Seconds]

=interval(round(YourMillisecondsField/1000)/(60*60*24),'hh:mm:ss') as YourNewField

[Chanty4u]

try this

interval(round(YourMillisecondsField/1000)/(60*60*24),'hh:mm:ss') as YourNewField

[sunny_talwar]

Is TimeInMs a number or an actual time field?

[puneetagarwal]

Its a number stored in db (datatype: Bigint)

[puneetagarwal · Accepted solution]

Tried this function , i was successfully able to convert into seconds.

But when i export to excel i am not able to perform the calculation on that column (Avg,Sum) etc.

[sunny_talwar]

I guess you got what you need... but this could be the other way to do this

=Interval(Interval#(TimeInMS/1000, 'ss'), 'ss')

[puneetagarwal]

Tried this function , i was successfully able to convert into seconds.

But when i export to excel i am not able to perform the calculation on that column (Avg,Sum) etc.

Note: The user wants to perform the mathematical calculation after exporting the excel on this column.