How can I just type a number eg 1130 for it to be formatted as time (24 hr) eg 11:30?

I'm working in excel and have to have the time in the HH:SS format but want to be able to just type in the number(s) and the time to be autoformatted. Is this possible? Thx