Excel formula to be ""

excel

#1

Hi All,

Can someone help me formulate this so that I could put it into a write range?

=ROUND((LEFT(C3,FIND(".",C3,1)-1)+((RIGHT(C3,FIND(".",C3,1)-1)/60)))-(LEFT(B3,FIND(".",B3,1)-1)+((RIGHT(B3,FIND(".",B3,1)-1)/60)))-1,2)

Thank you!


#2

Hi
I think you just store this formula in a string variable and using write cell with cell index variable to place in the destination excel file.


#3

what do u mean??


#4

It says identifier required. What does that mean?


#5

Hi
I meant you:

  1. firstly store this forluma in cell A1 of one excel named a.xlsx
  2. using read cell formula activity, read A1 of a.xlsx, and output it to one string variable named var_formula. kindly reminder, the equal sign would be missing in the output variable.
  3. using write cell activity to place “=” + var_formula as input to the destination cell of destination excel file i.e. b.xlsx