Convert number to Time 'hh:mm:ss'

[arpitkharkia]

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!

[antoniotiman]

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

[Anil_Babu_Samineni]

Would you able to provide sample application?

[jonathandienst · Accepted solution]

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)

[tajmohamed30]

please note the seconds format in QV is tt

[el_aprendiz111]

Hi,

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

[arpitkharkia]

Thank you for all the suggestions!

[QlikBeginner]

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.

[oliveira1903]

Hello.

Did you manage to solve it?

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

Thank you

[MarcoWedel]

please describe your issue in a new thread

thanks