Formating time in cells
I want to input time data onto a sheet, in the format of a 24 hour clock
(e.g. 09 45 or 17.30 etc).
However, when I select the hh:mm format from the time format options and
then input, say, 19.30, I get a strange date first and then a time which is
not the time I input.
How do I stop it adding the date and just show the time that I input?
|