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?

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

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?

--

Dave Peterson

Enter:
2:30
instead
--
Gary''s Student - gsnu200817

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)

On Mon, 1 Dec 2008 07:36:02 -0800, confused
<(E-Mail Removed)> 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?

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
<(E-Mail Removed)> 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?