I am tring to write a excel formula in ui path and its showing error as end of expression required

Help Studio
, ,
1

i am trying to write a excel formula in ui path and its showing error as end of expression required , this is the formula “=(TEXT(X10-V10,“hh:mm”)”

note : i am executing this formula in write cell activity .

can anyone give solution on this?

2

i think you missed bracket please use like this =(TEXT(X10-V10,“hh:mm”)) and try. thanks

3

You probably also need to ‘escape’ the quotes in the expression. (use double double quotes if you haven’t already)

So Assign: strFormula = "=(TEXT(X10-V10,""hh:mm""))"