PureCrazed
New Member
- Joined
- Oct 7, 2005
- Messages
- 30
Is there a way to format the cell where you can enter time without typing a colon?? My current format is [h]:mm but I have to enter the time exactly as 8:00 in order for the cell to read it as a time.
I want to be able to just enter a number and have it translate to time...
Example: enter "800" and excel will format it to look like "8:00" or enter "1700" and excel format it to "5:00" (I have to use military time to represent pm so it differs from am)...
I want to be able to just enter a number and have it translate to time...
Example: enter "800" and excel will format it to look like "8:00" or enter "1700" and excel format it to "5:00" (I have to use military time to represent pm so it differs from am)...