This code snippet is being used to calculate a time into a normal time in the H.M format. The numbers are something like 1.93 which means 1 hour and 93 minutes. I'm trying to convert this into 2.33 so it is more easily read/understood.
| eval x1=substr(Total_Time_Refresh,1,1)
| eval x2=substr(Total_Time_Refresh,3)
| eval x4=(x2/100)
| eval x3 = if(x4>=(0.60),((x4/.6)+x1),(x4+x1))
Unfortunately anytime the substring x4 is greater than .60 it returns a whole number 2 or 3 only.
Anyone have any ideas as too why it is doing this?
| eval x1=substr(Total_Time_Refresh,1,1)
| eval x2=substr(Total_Time_Refresh,3)
| eval x3=(x2/100)
| eval x5=((x3/0.6)+x1)
| eval x6=(x3+x1)
| eval x4=if(x3>=.6,x5,x6)
Edit: I spread out the code to troubleshoot it and the error lies in '| eval x5=((x3/0.6)+x1)'
It seems to be rounding the number to a whole number if it is over '2'. I don't know the reason why though.
... View more