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

%3CLINGO-SUB%20id%3D%22lingo-sub-3481456%22%20slang%3D%22en-US%22%3EI%20wanted%20to%20create%20a%20column%20where%20i%20can%20auto%20fill%20the%20calculation%20from%20c%20and%20d.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3481456%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20there%20i%20am%20trying%20to%20calculate%20the%20time%20so%20end%20time%20-%20start%20time%20and%20auto%20fill%20around%201m%20rows%20.%20anyone%20there%20to%20rescue%20me%20%3F%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3481456%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3481532%22%20slang%3D%22en-US%22%3ERe%3A%20I%20wanted%20to%20create%20a%20column%20where%20i%20can%20auto%20fill%20the%20calculation%20from%20c%20and%20d.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3481532%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1417551%22%20target%3D%22_blank%22%3E%40lamarajesh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimply%20just%20put%20the%20cell%20contain%20end%20time%20-%20the%20cell%20contain%20start%20time%2C%20just%20make%20sure%20you%20are%20putting%20the%20time%20in%20the%20correct%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA1%3D%20start%20time%2C%20B1%3D%20end%20time%3C%2FP%3E%3CP%3EThe%20formula%20you%20will%20use%20in%20C1%26nbsp%3B%20will%20be%3A%3C%2FP%3E%3CP%3E%3DB1-A1%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3481628%22%20slang%3D%22en-US%22%3ERe%3A%20I%20wanted%20to%20create%20a%20column%20where%20i%20can%20auto%20fill%20the%20calculation%20from%20c%20and%20d.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3481628%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1417551%22%20target%3D%22_blank%22%3E%40lamarajesh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20Mr.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F87534%22%20target%3D%22_blank%22%3EJihad%20Al-Jarady%3C%2FA%3E%3CSPAN%3E%26nbsp%3Balread%20write%2C%20a%20siply%20formula%20can%20do%20it%20this%2C%20but%20if%20you%20want%20it%20in%20VBA%2C%20hier%20a%20quick%20Solution%26nbsp%3BApproach.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ESee%20the%20insert%20file%2C%20is%20simply%20VBA%20examble.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3497293%22%20slang%3D%22en-US%22%3ERe%3A%20I%20wanted%20to%20create%20a%20column%20where%20i%20can%20auto%20fill%20the%20calculation%20from%20c%20and%20d.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3497293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B%20i%20am%20trying%20to%20auto%20fill%20the%20formula.%20did%20not%20work%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3498603%22%20slang%3D%22en-US%22%3ERe%3A%20I%20wanted%20to%20create%20a%20column%20where%20i%20can%20auto%20fill%20the%20calculation%20from%20c%20and%20d.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3498603%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1417551%22%20target%3D%22_blank%22%3E%40lamarajesh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EIt%20would%20be%20beneficial%20for%20everyone%20involved%20if%20to%20know%20about%20the%20Excel%20version%2C%20operating%20system%20and%20storage%20medium.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EA%20file%20(without%20sensitive%20data)%20or%20photos%20and%20step%20by%20step%20description%20based%20on%20this%20file%20or%20photos%20would%20also%20help%20a%20lot.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-US%2Foffice%2Fexcel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EExcel%20specifications%20and%20limits%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EThe%20button%20works%20for%20me.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EIf%20I%20press%20on%20it%2C%20the%20time%20difference%20from%20columns%20C%20-%20F%20is%20calculated%20or%20displayed%20in%20column%20D.%20Here%20is%20the%20file%20again%2C%20with%20empty%20column%20F...press%20the%20button.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3498783%22%20slang%3D%22en-US%22%3ERe%3A%20I%20wanted%20to%20create%20a%20column%20where%20i%20can%20auto%20fill%20the%20calculation%20from%20c%20and%20d.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3498783%22%20slang%3D%22en-US%22%3EMake%20sure%20you've%20created%20a%20table.%20If%20you%20create%20a%20table%2C%20column%203%20will%20be%20a%20calculated%20column.%20Then%20it%20will%20automatically%20copy%20to%20the%20rest%20of%20the%20rows%20in%20the%20table%3C%2FLINGO-BODY%3E
New 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