Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

convert a number to hh: mm: ss

Hi Community,

May I  know how to convert a number to hh: mm: ss?

3 Replies
MVP
MVP

Re: convert a number to hh: mm: ss

Format using:

=Time(0.56, 'hh:mm:ss')

=Time(yourField, 'hh:mm:ss')


This assumes a date/time value in units and fractions of a day. If the number is a decimal number of hours, you will need:


=Time(3.75/24, 'hh:mm:ss')

=Time(yourField/24, 'hh:mm:ss')

Re: convert a number to hh: mm: ss

Re: convert a number to hh: mm: ss

You can use Maketime, Time, Time#

From Qlik Help

MakeTime(hh [ , mm [ , ss [ .fff ] ] ] )


Or


Time( TimeField, 'hh:mm:ss' )


Or


Time#( TimeField, 'hh:mm:ss' )


You have another thread related to same


turn the number into hh: mm: ss (10:37:29)


Regards

Anand