Discussion Board for collaboration related to Qlik Education.
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 .
I might have a solution but a quick question. Do you really need the milliseconds?
=time(time#(num(floor($(v)/100), '000000'), 'hhmmss') + Right($(v),2)/(1000*3600*24), 'hh:mm:ss:fff')