Formamting time WITHOUT date

  • Thread starter Thread starter Fraggs
  • Start date Start date
F

Fraggs

I've been trying to format some cells to accomdate some data in the for
of time (hh:mm). I have tried all the time format options and trie
some of the custom format options but every time I enter some data int
the cells, its put that data into the date rather time. How to I mak
it so its the time that is shown and not the date as I dont need this.

Thank
 
Sorry - hit the send buttonto early!

How are you entering the data? Is it with a shortcut? Is it xx:yy? Is it
from an external program?

--
Andy.


Andy B said:
Hi

How are you entering the data?
 
When you enter 13:00, hit the Enter key, and then select the cell again,
what is shown in the formula bar (the bar immediately above the column
letters)?
 
Back
Top