Hello all,
I need a very basic time tracker that would allow me to hit a button to clock in every morning and clock out in the afternoon. I'd like it to auto populate a table that shows date, time in, time out, hours work, overtime (any time in excess of 8 hours). My VBA knowledge is maybe 1%. I know it exist. I appreciate anyone's assistance. I have tried to search google and various forums trying to find anything close but have had no luck. Thank you all. Have a great day!
Play around with attached...Developed a couple of years ago as a snippet for a Restaurant POS solution
Usernames in Col I
Passwords in Col J
Enter passwords to clock in Green Clock | clock out - red clock - print button to print report...
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Another one to play with and adapt.
Click in columns 'A' or 'B'
See you already got two reactions, let us know what you think. my version (fromm the post you found) is I think too much for what you want do achieve
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hello all,
I truly appreciate both of you posting examples for me to look at. Neither of the 2 given is what I'm looking for. The one posted by Sintek is a bit closer. But I don't like that the clock in and out interface doesn't allow me to navigate the background without closing it out. I'm posting an example of what I need the end result to look like. Hopefully one of you fine folks can help me get there. I'm sure this is quite simple for someone with excel knowledge. I put notes on the doc as well. This is going to be used for me only, so it doesn't need to be made for multiple users. Thanks again guys.
I've picked up your file and will look at it, won't be before 'next year', sounds far away but the year's over tomorrow
For now a HAppy New Year and you'll hear from me
This is a quickie
Give it a run
NOTICE: it only works within the same day if the time out is the next day you will have to provide for that in the formula calculation
The small form is modeless (you can access the sheet without dismissing the form).
If you dismiss the form with the 'X' click cell F1 to return it.
You can overwrite the last row by 'ticking' ov box.
Not fully tested as adapted from one of my previous submissions, should accommodate time in excess of 24 hour day.
Simple 'IN'> 'OUT' toggle action, time in excess of 8 hours set to overtime.
torachan.
Keebellah - This is something I was looking for. How can I modify where "C =Date" is not specific to a date. I would like for that selection to be whatever but it still records the clock in and out.
C is a dimensioned Range and is used for Column A to check the dates.
You can dimension is as a Variant BUT then you will have to include the check if C is a date value then do the date things.
I am getting an object not found error.
Please Login or Register to view this content.
Well, you starting a guessing game?
What if I told you when I press here it hurst there and you cannot see me
Well, my guess, but that's a great risk is that the macro doesn't know what PUNCHME_Click is
Without any clear information that's the most logical answer I can give you.
Originally Posted by torachan
Thanks man. This seems to be working well for me. Simple and doing the few things I needed. I appreciate it.
Also, thanks to the rest of you who offered help. It is all appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks