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

Occasional Visitor

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


1 Reply
Hi Maria

You are in the wrong forum (Microsoft Forms) and need to post this in the Excel forum.

The community will respond to your query there.