Can I turn the time into a number for calculations?

I want to convert from text to number for calculation.

Hi @Panupol_Sonnuam

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