Hello, I am using this formula in excel to exchange a text value to time : "=--TEXT(H7,"00:00:00")" , my text value format is "545". After that i use these value to calculate expect time value such as "=I7-(--TEXT($J$4,"00:00:00"))" (I7 is the value created from the first formula)
But when i copy this formula to honeycode, the system responsed #value.
Can you please suggest compatible formula in Honeycode ? Thank you.