time calcutation in a userform

[Del117]

I am trying to get brakes off time to be 6 minute before take off in the user form any ideas?

[AlphaFrog]

Put this in the Userform code module. When the user exits the Take_off_inputBox, it test if its value is a valid time entry, then subtracts 6 minutes from it and put that earlier time in the brakes_off_TextBox.

Please Login or Register  to view this content.

[Del117]

thats brilliant works perfect always find working with time in excel tricky
now just got to reverse engineer it to add time in landing + 00:06 for brakes on
thanks again
Del.

[Del117]

just looking at the code above in the If statement, If Len(Take_off_inputBox) Then 'If not empty
what is Len?

[AlphaFrog]

In the VBA editor, highlight Len in the code and press F1.

[Del117]

yup thanks forgot you could do that

[Del117]

hello again still having a few probs with time in the above user form i have land_time and subtract Take_off the result at the moment is in hh:mm how can i convert it into a "0.0" format?

[AlphaFrog]

hello again still having a few probs with time in the above user form i have land_time and subtract Take_off the result at the moment is in hh:mm how can i convert it into a "0.0" format?

By "0.0" do you mean decimal hours? If yes, multiply the result by 24 to convert it to decimal hours and display it with any decimal formatting you like.

How Excel Stores Dates And Times

[Del117]

yes here is my attempt

Please Login or Register  to view this content.

[Del117]

I should add I have tried * the above code by 24
have also tried

Please Login or Register  to view this content.