Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

darrin_pilkingt
Contributor II

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
MVP
MVP

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
MVP
MVP

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

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

darrin_pilkingt
Contributor II

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
Contributor II

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.

Community Browser