I want to convert from text to number for calculation.
I haven’t tried but you can do something like:
+Value.substring(0,2) + +Value.substring(3,2)/60
first part will get only the first 2 numbers.
second will divide 30 by 60 in this case, as if you want to get the actual number of a time you need to covert to decimal. If you don’t want this just replace the 60 by 100.
ps. the + in front of the value will covert to number.
1 Like