How Do You Enter 6Am Until 12 Pm In Time Format In Office Excel 2007?
I am assuming you do not actually want to put that in one cell because if you do you will not be able to make any calculations from it, but if you should for some reason, then put it in text format. I am hoping however you mean 06.00 in one cell, 0700 in next etc etc which means highlighting the cells firstly (which I think is best to always format before you enter the data) right button of mouse down to format cells, choose time from the right pane. However times are most peculiar and to start off you will need to type 6 followed by a space then a for it to come right (6 a) then 7 a etc.
