Good Day
I have a User Form whereby time is added. (See attached Form) I have created a lookup for time and created a drop down on the Form. However after I chose the required time it is entered into the form as a decimal number and also placed in that same format on the sheet. The lookup is in the Time Format. I then need to subtract the start time from the end time. This also does not give total time.
What am I doing wrong?
Please Help.
Thank You
Colin Smit
Since you have the times on the lookup sheet formatted as Time, the combobox tries to accommodate the value instead of the text when you use rowsource.
Clear the rowsource and add this code.
Then, you'll have to subtract B from A in Time sheet, and create a custom format for Column C as [h]:mm.
Please Login or Register to view this content.
David
(*) Reputation points appreciated.
Thank You for the help. I will now mark this thread as solved.
Will I be able to use similar coding for a date entry?
dates are a little more forgiving. You could... (BTW since both time comboboxes use the same time, you can combine the code a little.)
Please Login or Register to view this content.
Thanks Tinbedr...I will make a new post for the date entry as this post is solved.
Can you help me with the code for the date entry? I cannot get it to work right.Originally Posted by Tinbendr
dates are a little more forgiving. You could... (BTW since both time comboboxes use the same time, you can combine the code a little.)
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks