TIME VALUE NULL

[fmazzarelli]

Hi Community,

the source data has a value like  "83459 " which really should be 083459 and I should represent as 8:34:59. How to accomplish that?

The field is ClosedTime

[MK_QSL]

Load

  Num(ClosedTime,'000000') as ClosedTimeNum,

  Time(Time#(Num(ClosedTime,'000000'),'hhmmss'),'hh:mm:ss') as ClosedTime

Inline

[

  ClosedTime

  83459

];

[prat1507]

Hi Fabio

Use the below exp:

=MakeTime(right((83459-right(83459,4))/10000,2),

right((83459-right(83459,2))/100,2),

right(83459,2))

You can variablize or use a field instead.

Regards

Pratyush

[shraddha_g]

Try

time(Time#(num(Field),'hhmmss'),'hh:mm:Ss')