time

[mario-sarkis]

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]

anyone ??

[Anonymous]

Hi

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

[maxgro]

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