Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
May I know how to 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')
Is this the same post?
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