Its probably quite simple but I just cant work it out.
I have set the format of a cell as hhmm. I want to be able to enter times as 1035 for example, without the colon (10:35). When I type in the time (1035) it returns it as:
1902-10-31 00:00:00
however, if I put in 10:35 it then shows it as 1035! Have I made the question confusing enough?
/skunks