I am struggling with a very simple code I just want a simple time sheet that tracks time on different projects.
1. I want to enter a start day and Time (Start)
2. When click stop it records end time, duration and new start time on next row.
Thanks for any help!
Try, Cell(Row,Column)
or
Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Hi Vicarious
I see you have not made provision for Employee Name. have a look at attached and play around with it. Names are stored in sheet2
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 [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Add this line of code
belowPlease Login or Register to view this content.
in clock out code to work out durationPlease Login or Register to view this content.
How would you know if someone else does not Clock in and Out for another person?
Also, If a person has already Clocked in, he/she should not be able do so again before having Clocked out from the last Clock in.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
@ Winon
My sample attached was just a start for OP...I can give him my POS clock in system which allows for personalized passwords and pop up messages that do not allow for clock in's again etc etc
Hi sintek,
Ek sou graag wou sien dat jy dit doen vir groter aansien!
It is exactly what I was hinting at, sintek. You could tone it down a bit just so it cover those basics!
I recall you working on it a while ago.
Go for it!
OMG, it's been a long week, I have struggled with that part for an hour and couldn't get it. Thanks!
Originally Posted by mike7952
Try, Cell(Row,Column)
orPlease Login or Register to view this content.
Please Login or Register to view this content.
mike7952- OMG, it's been a long week, I have struggled with that part for an hour and couldn't get it. Thanks!
Let's see what Vicarious has to say. He seems happy with the solution from mike7952.Hi sintek,
Ek sou graag wou sien dat jy dit doen vir groter aansien!
It is exactly what I was hinting at, sintek. You could tone it down a bit just so it cover those basics!
I recall you working on it a while ago.
Go for it!
This is awesome! I don't need the employee name, each person will track their own time. But that might be nice to change to the different projects each one is working on. Very easy to pick from them then.
Thanks for the help I can get this to work! I hope...
K, Good luck. Let me know if you require a complex Clock in system. I designed one for my Restaurant POS System some time ago.
sinek,
A couple things I would like to change
1. How do I get the combobox1 to select more than 4 names?
2. When clocking out can we clear the combobox1?
3. The duration doesn't appear to be working.
With these minor changes it will be better than I thought it would be.
Thanks
Hi Vicarious
I have attached a sample of a basic time sheet that will fulfill your requirements. In Sheet2 Column A you can add as many names as you like.The combobox will be populated with all names. Give it a try and let me know if it is suitable.
@ winon
R you spying on me lol
Oops, just realized that I did not insert a check for if Combobox = "" prior to clock in or clock out
Put this line of code
in the command buttons for both IN & OUT just before line of codePlease Login or Register to view this content.Please Login or Register to view this content.
@ sintek,
Yep!With the Userform "Exit" Button, rather use Unload Me instead of App. Quit.
With the Sheet Clear Button, I believe only an appointed authorized user should be able to do that:
If you need help with this, I shall gladly help!Please Login or Register to view this content.
@ Winon
Thanks for feedback sweetie. Means alot. I was using Application.Quit to end the program after save.
Great idea for Selection clear password. Can amend if OP requires. Was not sure how he was going to implement.
This is awesome! Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks