How to convert the centesimal time format to the sexagesimal time format

[Samuelgomes]

good afternoon, I would like to know what function I can use to convert the hours from the database that comes in centesimal to the sexagesimal time format.

I need to perform an average time calculation. However the average that it brings is centesimal i'm using it this way currently

avg (EMX_HORAS_ACUMULADAS)

[Marcos_Ferreira_dos_Santos]

Hi Samuelgomes

Have you solved this by yourself ?

If you don't, please refer to previous post on this subject.

For example: https://community.qlik.com/t5/QlikView-App-Development/Calculate-time-difference-between-timestamps-...

In general, we can say that Qlikview treatment for time calculation uses special functions.

[marcus_sommer]

Did you try: interval(avg (EMX_HORAS_ACUMULADAS), 'Format')

- Marcus