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.

https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral

The community will respond to your query there.

Cheers
Damien