Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
The format of the time in the files I load is not how I want it to be and I need to change it.
This is the format of the files:
- After I add "Time(Time#...." some rows is correct, but some are not. Ex. Orig time 74752 (07:47:52) --> 03:15:02
- I guess that when the time is not equal to "hhmmss" it becomes an issue.
- How can I add in the script that some rows in the file are in this format "hmmss" and should be presented as "hh:mm:ss"?
* And another question is regarding the field "Completed time". This is in another format where ex. 15.15 = 15:09 (60*0,15=9)
- I want it to be presented as the previous example "hh:mm:ss"
Thanks in advance!
See if this is better
=Interval(Interval#(Num#([Completed Time], '##,##', ',', '.')*3600, 'ss'), 'hh:mm:ss')
HI,
Time(Time#(Num([Action Time],'000000'),'hhmmss'),'hh:mm:ss')
Regards,
Antonio
This should also work
Time(Time#([Action Time],'hmmss'),'hh:mm:ss')
try this,
=interval(Avg(YourField)/86400,'hh:mm:ss')
Thanks Antonio!
Should this be in the script? Because I get an error when I add this to the script.
If you got what you wanted, please close the thread by marking correct and helpful responses.
Best,
Sunny
My first question is answered. Still need help with the second.
May be this?
=Interval(Interval#(15.15*60, 'mm'), 'hh:mm:ss')
assuming 15.15 is 15 hours and 9 minutes
Or more generally
=Interval(Interval#([Completed Time], 'mm'), 'hh:mm:ss')