Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

mario-sarkis
Contributor

time

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,

3 Replies
mario-sarkis
Contributor

Re: time

anyone ??

morris70
Valued Contributor

Re: time

Hi

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

MVP
MVP

Re: time

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

Community Browser