Calculations times in UserForm

[john55]

Hi,
I'm trying to make automatically some calculations but all my work was in vain because I'm not sure how should it be done!
What the user should do is
first example from userform:
in the 1st table (time)
the user has a look in column B and see the departure time 18:15 between 17:00-04:59, choose how many sectors are needed and here are 2 -> and the time std=11:00 hours.
or time max (11:30)is find in the 2nd table.

the second example from userform:
the user has a look in column B and see the departure time 15:00, then adds 12:00 hours (time std)= 03:00 local time, subtracts 15 min, subtracts the trip time (03:00 hours) =23:15 a specific time
in other words, he has to depart at 23:15 in order not to exceed that 12:00 hours(time std).

For your reference I attached a test file and a pic.
I really appreciate your help!

after.jpg

[Norie]

How is the user selecting what is to appear in the userform?

What calculations do you actually want to do?

If you are working with times stored as text, ie values in textboxes, you might want to be looking at using TimeValue to get 'real' time values to use in your calculations.

[john55]

Hi Norie and thank you!

for the 1st example in my userform, the user types the departure time (whatever he needs), types the sector/s and the result should be the time, the intersection of "those lines"

the 2nd one
here are some calculations...
the user types the departure time, he has the time already calculated -the above example- (std time or duty time) and is written in that textbox, teh result is time, local time (i.e 09:00 + 08:00 (duty time)=17:00..... then 17:00-15min=16:45 - 00:55 (the way to home)=15:50 the time when our guy has to depart.

hope this is make sense...

[john55]

Hi all,
I solved it but not into userform, I have no ideea how to di it, just in a regular sheet...perhaps someone can help me.
Thank you!

[Norie]

Do you mean you still want to use a userform?

[john55]

well, I protected some cells, and the sheet also, in order not to delete the formulas by mistake...colored a little bit and it looks pretty nice! my colleagues are very happy!
Thank you, I think I'll stay with the simple sheet!