I want the macro to validate in such a way that it gives results for only the number of rows that have values in Cell g3= start date,cell h3= start time AND cell i3= finish date cell j3= finish time. This is coz sometimes i have sheets where there are 20 rows and sometimes it can run upto 1000s rows. Otherwise if the above condition is not fulfilled the cell should be blank without any values. So what i want is that the macro should be in such a way that it only computes and gives results IF there are values in cell g3,h3 AND cell i3,j3.(since i have to upload this data in a Database for my website, thats why the pain)
The macro is working perfectly but it is also calculating for cells that do not have start time or date and giving some vague and irrelevant results. Then a custom time formatting for column L and i get my results. Then it copies the contents of the results of column K and does a paste special in column L (i want values instead of formulas hence this step) In cell k1 it inserts the following formula to calculate time duration : =SUM(I3 J3)-SUM(G3 H3) ''btw formula is giving accurate results'' Before i proceed i just wanna give you a run through to what i have done till now. I have created a macro which calculates time duration.
0 kommentar(er)
