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

Copper Contributor

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.

5 Replies

Hi @lamarajesh 

 

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.

 

A1= start time, B1= end time

The formula you will use in C1  will be:

=B1-A1

@lamarajesh 

Like Mr. Jihad Al-Jarady alread write, a siply formula can do it this, but if you want it in VBA, hier a quick Solution Approach.

 

See the insert file, is simply VBA examble.

 

 

@NikolinoDE  i am trying to auto fill the formula. did not work

@lamarajesh 

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

 

*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.

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)

 

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