Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MalcolmCICWF
Creator III
Creator III

Convert/Format Decimal to Appropriate Time

So I have found pieces of this discussion, but have not received a solution trying to put them all together.

I have data where the field is represented in minutes and then divided by another field to get an Average Handle Time of a call. I get results where the average is .73 minutes, 10.6 minutes, and 85 minutes as examples. I need these minutes broken out into proper Hours, Minutes, and Seconds.

So far I have tried some Time formatting and taking the results *60, but cannot solve formatting the final results to hh:mm:ss successfully. What am I doing wrong? I am assuming it's easiest to do this right away in the script?

11 Replies
MalcolmCICWF
Creator III
Creator III
Author

This worked really well for me, thanks. I did remove the keepchar function though, I'm not sure how it would help me.

sunny_talwar

I didn't know if your data included minutes or not (0.73 vs 0.73 minutes)