# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
New Contributor

## int to hh:mm:ss

Hi,

I am converting seconds into hh:mm:ss like

= Interval(Interval#(SUM (Value),'ss'),'hh:mm:ss')

Conversion is working fine but if value is big number it is coming in -ve.

Test:

id,Value
1,1000,
2,25500000,
3,4556800000,
4,6767676767,
5,6767676767,

];

1 Solution

Accepted Solutions
Valued Contributor

## Re: int to hh:mm:ss

Hi,

To convert seconds into interval ('hh:mm:ss') use below expression:

interval(div(sum(Value),3600)&':'&(div(sum(Value),60)-div(sum(Value),3600)*60)&':'&mod(sum(Value),60),'hh:mm:ss')

Hope this helps.

Regards,

Andrei Kaliahin

6 Replies

## Re: int to hh:mm:ss

Are you really sure that you had values in seconds with these sizes?

6767676767 / 3600 / 24 / 365 = 214 years

- Marcus

Not applicable

## Re: int to hh:mm:ss

Hi

can you attach a sample for you req?

-Amay

Valued Contributor

## Re: int to hh:mm:ss

Hi,

To convert seconds into interval ('hh:mm:ss') use below expression:

interval(div(sum(Value),3600)&':'&(div(sum(Value),60)-div(sum(Value),3600)*60)&':'&mod(sum(Value),60),'hh:mm:ss')

Hope this helps.

Regards,

Andrei Kaliahin

MVP

## Re: int to hh:mm:ss

Hi,

Try like this

Test:

Floor(Value/ 3600) & ':' & Floor(Mod(Value, 3600)/60) & ':' &  Mod(Value, 60) AS HHMMSS

inline [
id,Value
1,1000,
2,25500000,
3,4556800000,
4,6767676767,
5,6767676767

];

Hope this helps you.

Regards,

Jagan.

New Contributor

## Re: int to hh:mm:ss

Hi Andrei,

The expression worked as expected . Thank you.

Regards,

Ashish

MVP

## Re: int to hh:mm:ss

seems to be a limitation of the Interval#() function rather than the Interval() function:

```= Interval(SUM (Value)/86400,'hh:mm:ss')
```

is working for me.

regards

Marco