6 Replies Latest reply: May 31, 2017 1:53 AM by Arpit Kharkia

# 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!

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

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

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

Would you able to provide sample application?

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

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)

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

please note the seconds format in QV is tt

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

Hi,

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

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

Thank you for all the suggestions!