Numbers in textbox appear as hh:mm in sheet

Good morning all

I have a userform and i want to type numbers into textbox and then that numbers to be sent to
my sheet as hh:mm. I've tried different ways (i changed the cell format...) but i can not figure out. I want to type 6.22 (or 622) and in sheet to appear as 06:22, or type 12.45 (or 1245) and it appears as 12:45. is it possible?

much appreciat your help
attached a sample

tim

one way

Please Login or Register  to view this content.