I wanted to create a column where i can auto fill the calculation from c and d.

Question

hi there i am trying to calculate the time so end time - start time and auto fill around 1m rows . anyone there to rescue me ? Thank you.

jihad al-jarady · Answer

Hi&nbsp;lamarajesh&nbsp;&nbsp;Simply just put the cell contain end time - the cell contain start time, just make sure you are putting the time in the correct format.&nbsp;A1= start time, B1= end timeThe formula you will use in C1&nbsp; will be:=B1-A1

nikolinode · Answer

lamarajesh&nbsp;Like Mr.&nbsp;Jihad Al-Jarady&nbsp;alread write, a siply formula can do it this, but if you want it in VBA, hier a quick Solution&nbsp;Approach.&nbsp;See the insert file, is simply VBA examble.&nbsp;&nbsp;

lamarajesh · Answer

NikolinoDE&nbsp; i am trying to auto fill the formula. did not work

nikolinode · Answer

lamarajesh&nbsp;It would be beneficial for everyone involved if to know about the Excel version, operating system and storage medium. A file (without sensitive data) or photos and step by step description based on this file or photos would also help a lot.Excel specifications and limits&nbsp;*The button works for me. If I press on it, the time difference from columns C - F is calculated or displayed in column D. Here is the file again, with empty column F...press the button.&nbsp;Thank you for your understanding and patience&nbsp;NikolinoDEI know I don't know anything (Socrates)&nbsp;

beyk40 · Answer

Make sure you've created a table. If you create a table, column 3 will be a calculated column. Then it will automatically copy to the rest of the rows in the table

Forum Discussion

I wanted to create a column where i can auto fill the calculation from c and d.

Share

Resources