Time format

[war24]

Hello
Can you help me Guys about the calculation of two time
The start time and end time how I subtract it using a code in user form

Private sub Tb11_change()
Me.Tb11.value = timevalue(Tb10.value) - timevalue(tb9.value)
End sub

 

[war24]

You can edit the code to display seconds as well:

Private Sub Tb10_Exit(ByVal Cancel As MSForms.ReturnBoolean)
    Me.Tb11.Value = Format(TimeValue(Me.Tb10.Value) - TimeValue(Me.Tb9.Value), "hh:mm:ss")
End Sub

Have you tried the attachment in post 6, do the minutes display right there?

Yes i tried but nothings happen and also there is no Error on that

 

[Georgiboy]

You may have to download the attachment rather than use it in the online version of Excel.

On the attachment, try putting a time in the first two text box's and then press enter. What value do you get in the third box?

 

[war24]

Still Nothings appears