How do I write time in Excel without a colon?
If you want to enter or import time values into Microsoft Excel without using colons, there are a few different ways that you can do so. One way is to use the text input method, where you would type the time value into the cell followed by the letter "a" for AM or "p" for PM.