Entering hours and minutes into cell without using ":&q

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)...
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
Hey erik, I was going to post the same link :rolleyes:

With formatting alone you can make 800 look like 08:00 with a custom format of

00\:00

but the underlying value will still be 800 if you use it in a calculation...
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,538
Members
410,547
Latest member
htran4
Top