Capture user name, login and logout times and calculate hours worked скачать в хорошем качестве

Capture user name, login and logout times and calculate hours worked

We can capture the user-name, login and logout times and then calculate the number of hours worked automatically using Excel VBA. We need 3 files: 1. The file in which we wish to work 2. Log-details file 3. User-name and password file against which we can confirm the correct user-name and password entry of the person logging in. When we open our workbook a login form is presented. After confirming our credentials we can start working. In the process our user-name and login time is recorded. We ensure that the user cannot close the workbook without logging in. This is done by disabling the cancel button 'X' on the right corner of the user-form using an IF statement. Most of the details have already been discussed in earlier videos. A few links are given below: 1. http://www.exceltrainingvideos.com/ho... 2.    • Find Next Empty Row for Data Entry using E...   - find next blank row 3. http://www.exceltrainingvideos.com/co... - how to check whether a workbook is already open After finishing our work we close the file and the macro or VBA code automatically records the logout time. In the log-details file we run an interesting macro that calculates the amount of time we have worked.