This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am adding two ToNumbers() and want to divide the result by a constant. Can someone help?
The statement does not give me the division by 60
(ToNumber([Hour1]) + ToNumber([Minute 1])) /60
I have fields Hour1 and Minute which gives me say 13 Hrs and 45 minutes.
I want to calculate 13+45 / 60 = 58/60 = .96
I tried with two versions, first using RegEX and second only ToNumber function and they worked perfect.