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: