Skip to main content
cancel
Showing results for
Search instead 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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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

please describe your issue in a new thread

thanks

Community Browser