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

On Mon, 1 Dec 2008 07:36:02 -0800, confused
wrote:

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?