Jun 08 2022 04:02 AM - edited Jun 08 2022 04:04 AM
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.
Jun 08 2022 04:32 AM
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
Jun 08 2022 05:03 AM
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.
Jun 12 2022 06:06 AM
@NikolinoDE i am trying to auto fill the formula. did not work
Jun 13 2022 12:05 AM - edited Jun 13 2022 12:12 AM
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
I know I don't know anything (Socrates)
Jun 13 2022 12:58 AM