topic Re: how to change a series of numbers into time format in Discussions

how to change a series of numbers into time format

SuperBigRabbit — Sat, 10 Jun 2023 23:53:57 GMT

Hello!

Can anybody help changing a series of numbers into time format [hh:mm:ss] here.

Originally, the data type is character. So, I've tried changing the data type from character to numeric to set format as [hh:mm:ss] but I failed...

I have no idea what to do now.

What I'd like to see as a result is, taking an example of 000003, 00:00:03..

It should not be that difficult, but I can't find a way...

And here's the data I'm dealing with now.

[column1] Original Date => [column2] After changing data type from character to numeric ==> [column3] After setting time format

Thank you in advance

jthi — Thu, 08 Sep 2022 07:01:56 GMT

If I understand the "original" format correctly, one option would be to first convert first column to seconds by using formula like:

Num(Left(:Column 1, 2))*60*60 + Num(Substr(Column 1, 3, 2))*60 + Num(Right(Column 1,2));

and then convert that to duration format

Georg — Thu, 08 Sep 2022 12:08:15 GMT

Another possibility is using informat:

SuperBigRabbit — Wed, 14 Sep 2022 05:45:51 GMT

This totally solved the issue.

Thank you a lot!