# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for
Did you mean:
Creator III

## Convert number to Time 'hh:mm:ss'

Hi all,

I have the following table in which all the data present is in seconds. All the data is generated using sum() function or some basic arithmetic calculation. I want the data in 'hh:mm:ss'  format.

Thanks for the help!

1 Solution

Accepted Solutions
Partner - Champion III

You will need to convert the values to QV time values and then format the values to time format.

In each of your expressions that return seconds, convert to QV time by dividing by 24*60*60 = 86400 (seconds per day) and then apply the format hh:mm:ss to the column in the chart properties number tab.

As an example, the expression for Avg Dial time:

=Avg(....) / 86400   (existing expression divided by seconds per day)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
9 Replies
Master III

=Time(Time#(19227,'ss'))  -> 05:20:27

Would you able to provide sample application?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner - Champion III

You will need to convert the values to QV time values and then format the values to time format.

In each of your expressions that return seconds, convert to QV time by dividing by 24*60*60 = 86400 (seconds per day) and then apply the format hh:mm:ss to the column in the chart properties number tab.

As an example, the expression for Avg Dial time:

=Avg(....) / 86400   (existing expression divided by seconds per day)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Creator III

please note the seconds format in QV is tt

Specialist

Hi,

=Interval(interval#(ceil(seconds),'s'), 'hh:mm:ss')

Creator III
Author

Thank you for all the suggestions!

Contributor

I have a question with regards to a similar situation:

All my time formats are in 24 hour format:

Example 1: 234832

Example 2: 023704

I would like to convert that into 24 hour time format - do you have any suggestions?

I have used Time(Time#(234832,'HHMMSS'), 'HH:MM:SS'), but it converts only few numbers into the right time format.

Contributor III

Hello.

Did you manage to solve it?

I'm having this same problem. Any tips? =]

Thank you

MVP