Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Samuelgomes
Contributor
Contributor

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

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)

2 Replies
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
MVP & Luminary
MVP & Luminary

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

- Marcus