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!

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!

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.

what do u mean??

It says identifier required. What does that mean?

Hi

I meant you:

- firstly store this forluma in cell A1 of one excel named a.xlsx
- 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.
- using write cell activity to place “=” + var_formula as input to the destination cell of destination excel file i.e. b.xlsx

1 Like