Hi Everybody
I'm new to the forum and looking for some assistance with the attached sheet. I have some notes in the sheet as to what i'm trying to solve. If anybody would care to take a look I would appreciate it!
Thanks
Hi Everybody
I'm new to the forum and looking for some assistance with the attached sheet. I have some notes in the sheet as to what i'm trying to solve. If anybody would care to take a look I would appreciate it!
Thanks
You have over complicated the job.
Selecting any cell that requires a time should automatically insert the time.
Right Click on the Sheet Name at the bottom of Excel and select view code.
Paste this code into the module that opens and then close it.
Formula for S16Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Formula forT16Formula:Please Login or Register to view this content.
Formula for U16Formula:Please Login or Register to view this content.
Last edited by mehmetcik; 04-15-2018 at 04:12 AM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks for help this works except when i click the new sheet button it inserts a time in the first cell requiring a time without clicking it, it needs to stay blank until clicked. I like that once clicked and the time is entered and clicking again it doesn't change.
Thanks
Modify your code to:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks