Sub traitement()
Date = UserForm1.Calendar1
Nom = UserForm1.ComboBox1
Ajout = UserForm1.TextBox1
x = Split(Ajout, ":")
Z = x(0) / 24 + x(1) / 1440
If Z < 0 Then Z = Z - 1 / 24
Sheets("Feuil2").Range("A65536").End(xlUp)(2) = Date
Sheets("Feuil2").Range("B65536").End(xlUp)(2) = Nom
Sheets("Feuil2").Range("C65536").End(xlUp)(2) = Z
Sheets("Feuil2").Range("C65536").End(xlUp).NumberFormat = "[hh]:mm;[Red]-[hh]:mm "
End Sub