Vba Time Elapse Help

[gustgio]

I need to create a time elapse between to cell entries

Column A - Once a cell in that field is populated, the clock begins ticking.
Column B - The real-time age in dd:hh:mm is populated in this column
* Column M & N - Once dates are populated in both of these columns, the clock in Column B Stops at that point.
Keep in mind A starts clock; and displays current time in B
Clock stops once BOTH M & N are populated.
Display the difference in the elapsed time in Collumn O
Also O2 can not recalulate when calcualting O3,O4, and so on..the script for the preceding cells needs to end and start fresh for every entry across rows = clock starts fresh wehn entering additonal info in a3, a4,a5 etc,and stops and keep the value when BOTH M& N are entered. O needs to be static and not change after antoehr instance of the clock starts..

 

[Gerald Higgins]

Hi, welcome to the board.

Your post is pretty vague, but I've used macros that measure elapsed time between events.

Here's how I've done it - there are almost certainly better ways.

'=== CAPTURE START TIME IN CELL A1
Range("A1").Select
    ActiveCell = "=NOW()"
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues
 
'=== INSERT HERE THE CODE FOR WHAT HAPPENS BETWEEN THE START TIME AND END TIME
 
'=== CAPTURE END TIME IN CELL A2
Range("A2").Select
    ActiveCell = "=NOW()"
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues

Then, use a separate cell containing

=A2-A1

which will give you the elapsed time.

The way I use this is to have all of this done in a single macro, so that it tells me how long it takes for the macro to run, but you could have each part in a separate macro, so long as you are confident that the start and end times are being captured at the correct points in whatever your process is.