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?

Enter time as 19:30 rather than 19.30 (with a colon NOT period as delimeter).

"Neil" wrote:

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?

Briillant, thanks.
Why didn't I think of that?

"Toppers" wrote:

Enter time as 19:30 rather than 19.30 (with a colon NOT period as delimeter).

"Neil" wrote:

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?