Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

darrin_pilkingt
Not applicable

How to convert whole numbers into seconds then amounts of time?

I have a table that contains seconds of time for calls but it is as whole numbers as below.  I am trying to convert this into quantity of time like hours:minutes:seconds

Data stored:

7635

31

9690

Would like to convert to:

7635   = 2:07:15 

31      = 00:00:31

9690   = 2:41:30

Thank for the help.

1 Solution

Accepted Solutions
Highlighted
tresesco
Not applicable

Re: How to convert whole numbers into seconds then amounts of time?

=Time(Time#('9690','ss'),'hh:mm:ss') ---------2:41:30

3 Replies
Highlighted
tresesco
Not applicable

Re: How to convert whole numbers into seconds then amounts of time?

=Time(Time#('9690','ss'),'hh:mm:ss') ---------2:41:30

darrin_pilkingt
Not applicable

Re: How to convert whole numbers into seconds then amounts of time?

Don't you just love when you ask a question and 30 seconds later you find the answer you were looking for.

=interval(interval#(sum(FieldName),'ss'),'d hh:mm:ss')


darrin_pilkingt
Not applicable

Re: How to convert whole numbers into seconds then amounts of time?

Tres, thanks for the extremely quick response.  I see as always, there are many ways to skin a cat.