Useform Build

I know this is really cheeky but at the risk of having the post removed I thought I’d give it a go anyway....it’s not that I’m lazy it’s just that it’s destroying me to come up with the answer when I know what I want but don’t know how to get there.

I have attached the file I have created thus far. It involves a table which will contain the overtime I will work over a period of time.

It also contains a userform that I have put together in order to automate the data entry...but I have the following problems/ ideas....but with no idea how to implement them!

The spreadsheet.

Pretty self explanatory...with the following issues...!

Example Tab – shows what I wish to achieve from the only way I know how to at the moment.

HoursEntry Tab – Shows how I want it to look. The yellow highlighted ells are those that could be populated via calculations or other formulae.

-I have had to format the Date & Time input areas to “Date & Time” together otherwise I cannot figure out how to accurately calculate the time “actually” worked vs. That “rostered” to work.

-I have had to include a “Date” column, otherwise I couldn’t lookup the W/C date from the Date & Time formatted cells.

The Userform.

I have also included a mockup of a userform which I have created to facilitate the date/ time entry options.

It will appear really basic to those knowledgeable amongst you...but to me it is earth shattering!

The problems I have are as follows.

-I can’t format or validate the entry fields to ONLY accept a relevant entry i.e. Date or Time. My intention is to tab between the fields as I enter the data.

-Failing this it would be nice to have a pop-up calendar to facilitate Date and/or Time entry but I don’t even know where to start....!

Many many thanks to anyone good enough to push me in right direction!!!!!

Try asking a specific question.