please i am trying to automate this process using a drop down list with formulars. i want to be able to get the total time spent in the office with a name. there are various people, various TIME IN and TIME OUT. i dont have VBA enabled, is there any way i could get this done. ALSO NOT the numbers (1,2,3) represent last names janitors, just to differentiate them. i will appreciate the help, thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
automating A TIME IN and TIME OUT process.
please i am trying to automate this process using a drop down list with formulars. i want to be able to get the total time spent in the office with a name. there are various people, various TIME IN and TIME OUT. i dont have VBA enabled, is there any way i could get this done. ALSO NOT the numbers (1,2,3) represent last names janitors, just to differentiate them. i will appreciate the help, thanks.
Excel Facts
Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
ranman256
Well-known Member
- Joined
- Jun 17, 2014
- Messages
- 2,397
you need to enable vba.
make a userform,
user enters their name (or Emp#)
combo box : IN or OUT
click SAVE
this will save to the sheet
[EMP], [IO], [TIMESTAMP]
And of course there will be screwups, where they forget to clock In (or out), so youd have to do some validation on the end results to fix the errors.
make a userform,
user enters their name (or Emp#)
combo box : IN or OUT
click SAVE
this will save to the sheet
[EMP], [IO], [TIMESTAMP]
And of course there will be screwups, where they forget to clock In (or out), so youd have to do some validation on the end results to fix the errors.
Upvote
0
Similar threads
- Question
