topic Re: time in Qlik Learning Discussions

time

mario-sarkis — Thu, 13 Nov 2014 13:07:04 GMT

hi All,

i have a field that contain a strating time as >>> '7423590' i need to show it like this 7:42:32:90 am (hours ,minutes,seconds,milliseconds)

and another filed that contain the ending time as >>'7435789' i need to show it like this 7:43:57:89 am (hours, minutes,seconds,milliseconds)

and finaly i need a field that will show me the diffrence time between the starting and the ending time .

Thank you,

mario-sarkis — Thu, 13 Nov 2014 13:27:46 GMT

anyone ??

Anonymous — Thu, 13 Nov 2014 20:23:06 GMT

I might have a solution but a quick question. Do you really need the milliseconds?

maxgro — Thu, 13 Nov 2014 20:38:27 GMT

=time(time#(num(floor($(v)/100), '000000'), 'hhmmss') + Right($(v),2)/(1000*3600*24), 'hh:mm:ss:fff')