Cell Format for Time
 

I have a simple worksheet for entering values on specific dates and plotting
them. I am trying to add a column to record the time that the values are
taking but when I format a cell for time, the cell displays 0:00 for all
times entered. The formula line reads 3/10/1902 12:00:00 AM. This occurs
for any number values entered either in a time format or otherwise.

Cell Format for Time
 

Try entering 3/10/2002 9:00:00 AM - note the year
Tell us what you see
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"patoda" wrote in message
...
I have a simple worksheet for entering values on specific dates and
plotting
them. I am trying to add a column to record the time that the values are
taking but when I format a cell for time, the cell displays 0:00 for all
times entered. The formula line reads 3/10/1902 12:00:00 AM. This occurs
for any number values entered either in a time format or otherwise.

Cell Format for Time
 

The problem is that you haven't entered a time. In that cell you have a
number 1007; if you want a time, put it in as 10:07 (with a colon).
--
David Biddulph

"patoda" wrote in message
...
I have a simple worksheet for entering values on specific dates and
plotting
them. I am trying to add a column to record the time that the values are
taking but when I format a cell for time, the cell displays 0:00 for all
times entered. The formula line reads 3/10/1902 12:00:00 AM. This occurs
for any number values entered either in a time format or otherwise.

Cell Format for Time
 

Thanks, that did it.

"David Biddulph" wrote:

The problem is that you haven't entered a time. In that cell you have a
number 1007; if you want a time, put it in as 10:07 (with a colon).
--
David Biddulph

"patoda" wrote in message
...
I have a simple worksheet for entering values on specific dates and
plotting
them. I am trying to add a column to record the time that the values are
taking but when I format a cell for time, the cell displays 0:00 for all
times entered. The formula line reads 3/10/1902 12:00:00 AM. This occurs
for any number values entered either in a time format or otherwise.