I am doing my time sheet, as it is a share resoure, other colleagues will use
it as well. Try to save our time, we will type 1630 instead 16:30
how can i set up the Excel so it will auto turn the 1630 as 16:30 time
format as i need this format for the formular.

many thanks