convert a number to hh: mm: ss

[fmazzarelli]

Hi Community,

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

[jonathandienst]

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')

[MK_QSL]

Is this the same post?

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

[its_anandrjs]

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