VBA Tool to Track Start and End Time (Time & Motion Tracker)


18

Here is one more wonderful free tool from ExcelSirJi.com which makes your life easy. Time & Motion Tracker helps you to track Start and End time of any type of transaction or activity. The good thing is, it is VBA based tool which helps you to protect from manual manipulation in the data by the user. It is also easy to use, just click on Start (shortcut: Ctrl+Shift+A) or Stop (Ctrl+Shft+S) buttons to record the time

Note:
1. If you want to add more columns in the tracker. Click on Reset and add them after column F (Duration)
2. To avoid manual changes in the time tracked; Date, Start Time, End Time and Duration columns have been protected with a password

Excel Tricks

How to use this tracker:

1. Save the hyperlink attachment in your system Time & Motion Tracker
2. Unzip the file and open
3. Click on ‘START’ or Ctrl+Shift+A when you start your transaction

Excel Tricks

4. Click on ‘STOP’ or Ctrl+Shft+S when your transaction is complete

Excel Tricks

5. Transaction ID and Remarks are option fields

Excel Tricks

6. To reset the tracker and clear the tracked data, click on Reset button

Excel Tricks

18
Leave a Reply

avatar
9 Comment threads
9 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
10 Comment authors
Clare CCarolMAnish KumarexcelsirjiChristian Recent comment authors
newest oldest most voted
Ravi Thakur
Guest
Ravi Thakur

Hi,

Can you please email me this template ? @ ravi_thakur34@yahoo.com

Thanks for your help 🙂

Pat
Guest
Pat

how do i unprotect this sheet?

Sujit
Guest
Sujit

can u pls send me this time and motion template to me. its look good and i need it to implement.

Mark
Guest
Mark

Can you send me a copy of the template please.

Michael Castro
Guest
Michael Castro

Hi,
Started using the template and it is really very useful .
Great job!

Christian
Guest
Christian

Hi,

Having an error when stop time. Pls help. Thank you

Basic runtime error. ‘1’

MAnish Kumar
Guest
MAnish Kumar

Hey, can you mail me this, I am doing a time and motion study, it would actually help

Carol
Guest
Carol

Hello,
I’ve downloaded the sheet but the password does not work, can I double check it is pwd@123 password.?

Clare C
Guest
Clare C

I cannot seem to get this to work it says ‘compile error, cannot find project or library’. thanks

VBA Code to Delete File
EXCEL VBA TRICKS
VBA Code to Delete File

In this article we are going to show you how you can delete file or files using a single line of VBA code. 1. Delete a specific file from the folder, 2. Delete specific type of files from the folder, 3. Delete all files from the folder

VBA Code to Add Border to Excel Range
EXCEL VBA TRICKS
VBA Code to Add Border to Excel Range

Through formatting the cells, you can make your Excel data more beautiful and easier to understand. If you record a macro to add borders to Excel range, you will notice that it generates 30 plus lines of code for just a small work. Here we are sharing one line of code which does the same thing.

Protect Excel Sheet for Manual Input
EXCEL VBA TRICKS
VBA Code to Protect Excel Sheet for Manual Input but Allow Programming Inputs

Did you come across any requirement where you want the user to interact with a sheet only through VBA Form? Here is a simple code which can help you.