Hi,

I have three text boxes on my worksheet.
They are for Start Time, End Time and Time Half Way between the start and end time.
I want the third text box to calculate the half time when both start time and end time are entered.

I tried the code below, but it won't tiger. Please help.
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    Dim startTime, endTime As Double
    
    startTime = TimeValue(TextBox1.Value)
    endTime = TimeValue(TextBox3.Value)
    
    
    TextBox4.Value = Left((endTime - startTime), 4)
    
End Sub
Thank you very much,