Time Format

[#1]

Hello guys! I have a question that must been very dumb but I can´t find the solution :(. I have in a column numbers as 312.5, 350.4 …which represent hours and mins.

I would like to have these numbers in the following format 312.5 as 312:50:00, 350.4 as 350:40:00..

Anny idea?

Thank you!!

[Chanty4u]

try this

stampp:

LOAD * INLINE [

    date

    312.5

    350.4

];

Result:

LOAD *,

Timestamp(Timestamp#(date,'hhh.m'),'hh:mm:ss') as new

Resident stampp;

[puttemans]

Hi,

If your values are correct, then try

subfield( time, '.', 1)&':'&(subfield(time, '.',2)*10)&':00' as newtime

where 'time' is the name of your original value, and newtime the new variable.

Regards,

Johan

[sunny_talwar · Accepted solution]

May be this:

Table:

LOAD *,

  Interval(Interval#(Floor(Time), 'h') + Interval#(Round(Frac(Time) * 100), 'mm'), 'h:mm:ss') as New_Time;

LOAD * Inline [

Time

312.5

350.4

];

[#5]

Thank You very much Sunny T.

It worked perfectly!!