Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Load
Num(ClosedTime,'000000') as ClosedTimeNum,
Time(Time#(Num(ClosedTime,'000000'),'hhmmss'),'hh:mm:ss') as ClosedTime
Inline
[
ClosedTime
83459
];
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
Try
time(Time#(num(Field),'hhmmss'),'hh:mm:Ss')