To Change to Time

[mmustkee]

Hi,

Can you please help me charging the below table to time format without changing column and output should be as result column?  Thanks in advance.

Time	Result
0.220833	5:18
0.220833	5:18
5.42E-02	1:18
5.83E-02	1:24
5.42E-02	1:18
0.25	6:00
5.42E-02	1:18
5.42E-02	1:18
5.42E-02	1:18
7.50E-02	1:48
5.42E-02	1:18
5.42E-02	1:18
5.42E-02	1:18
7.50E-02	1:48
5.42E-02	1:18
0.0625	1:30
5.00E-02	1:12
4.58E-02	1:06
5.42E-02	1:18
0.15	3:36
7.50E-02	1:48

[Qiu · Accepted solution]

@mmustkee 
I tried with ToDateTime Function

[atcodedog05]

Hi @mmustkee 

Here is my approach. I am using todatetime() to convert number to datetime similar to @Qiu . But instead of substring to capture a part of string i am using datetimeformat() to show only hours:mintues. 

Hope this helps 🙂

[Qiu]

@atcodedog05 
This looks better. 👍

[mmustkee]

Hi,

Solution worked but what if Time column has data type as VString.

Can we do that without changing data type from he formula tool.

[mmustkee]

HI Qiu,

Thanks for the solution and it worked too. But could you please explain what does length 11,5 means. what if if we put 12,4, or 24 or any number. Could you please explain how does this substring formula works.

Thanks for your help as always.

[atcodedog05 · Accepted solution]

Hi @mmustkee 

to answer 2 of your question.

1. If time field is string instead of double does it work? 

Ans: No, ToDateTime(x) can take only numeric field

2. Why is substring set to 11,5 ?

Ans: Substring takes following arguments Substring(String,start,length) . Here [Time] is the column, 11 is start position and 5 is the  length. So it takes 5 chars from 11th position.

Hope this helps 🙂

[Qiu]

@mmustkee 
Thank you for the answer. 😁