Time calculation

[shamitshah]

Hi,

I have the following which have been converted to time, but I need a formula in Qlik to do the same:

Action Time             Converts to the following time

48240                       13.24.00

48249                       13.24.09

The formula is as follows with respect to the first example above:

Hour worked out as 48240/3600 = 13.4  (hour is 13)

Minutes - remainder/60 = 1440/60 = 24 (minutes is 24)

Seconds will 00 as there is no remainder

Any idea how I can incorporate the above in Qlik?

Thanks

Shamit

[shamitshah]

Hi Pooja,

Please attach your solution.

Thanks

Shamit

[eromiyasimon · Accepted solution]

hi shamit,

i have loaded in script and attached you the QVW

[shamitshah]

Thanks!

[Anil_Babu_Samineni]

Can you try this for me

LOAD *, Time(Time#([Action Time],'sssss'),'h:m:ss') as Converts to the following time INLINE [

Action Time

48240

48249

];

And take table box, With the names are [Action Time] & [Converts to the following time] and then see.