cell format to h:mm

[confused]

when I format my cells to the h:mm format and type in a number (230) and hit
return, I get something completely different. I get a date and time that
isn't anythink like the time I typed in. Can someone please help me?

 

[Dave Peterson]

You have to tell excel that you're entering time with a colon ).

2:30
or
0:2:30

Or you could use a macro like the one that Chip Pearson shares:
http://www.cpearson.com/Excel/DateTimeEntry.htm

 

[Gary''s Student]

Enter:
2:30
instead

 

[Chip Pearson]

The format of a cell governs only the way the value is displayed
within the cell. It has nothing at all to do with the format you must
use to enter the data. You still need to include the ":" character in
the time string to tell Excel that you are entering a time, regardless
of how you have formatted the display value of the cell.



Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Gord Dibben]

What you are trying to do is not possible without VBA or a helper cell with
a formula.

Formatting a cell to h:mm does not create an input mask.

Either enter the time as 2:30 or see Chip Pearson's site for quickentry
code.

http://www.cpearson.com/excel/DateTimeEntry.htm


Gord Dibben MS Excel MVP