itsmevic
asked on
Excel 2010: Start / Stop Timer Macro Button
Hello Experts!
I'm needing a macro that consists of a start and stop button that will track time on each row in my spreadsheet. The start and stop button will be in each row as shown below. This allows the user to track true time and click on the start when the job actually begins and when it actually stops. The Time Worked column will more than likely be Column L where the Start and Stop button will be in Column M. Does anyone have a toggle or two button macro that can do this?
Time Worked (Button 1) (Button 2)
data data data data 00:12:23 <<<<< START STOP
data data data data 00:04:54 <<<<< START STOP
data data data data 01:12:04 <<<<< START STOP
and so on and so on....
Your help is greatly appreciated.
I'm needing a macro that consists of a start and stop button that will track time on each row in my spreadsheet. The start and stop button will be in each row as shown below. This allows the user to track true time and click on the start when the job actually begins and when it actually stops. The Time Worked column will more than likely be Column L where the Start and Stop button will be in Column M. Does anyone have a toggle or two button macro that can do this?
Time Worked (Button 1) (Button 2)
data data data data 00:12:23 <<<<< START STOP
data data data data 00:04:54 <<<<< START STOP
data data data data 01:12:04 <<<<< START STOP
and so on and so on....
Your help is greatly appreciated.
Is this a duplicate of your previous question?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Much simpler to use a start and stop time column. ;)
:-)
Could someone post an example file that does this. I'm new to VBA (as in never touched it until today) and a full example file would be extremely helpful.