Hi. I have a userform for data input. One of fields required is amount of time it took a worker to complete a job. How can I format the textbox so that for example if I typed in 0130 it would format it as 1hr 30mins.

No task will take longer than 24 hours.

Cheers for your help