Microsoft Excel

[anotheoldgit]

I wish to enter dates in an Excel chart.

I have highlighted a whole column.

Selected Format, Cells.

Number Tag.

Time.

Type.

And select the 1.30 pm example, and then pressed OK.

But when I type in 16.30 7.12AM is displayed in the cell.

If I continue with 17.30, 18.30, etc 7.12AM is still displayed

But if I enter 23.00 12.00AM is displayed

Why is this please?

[nannybooby]

what excell are you using ?

[ChuckFickens]

You need to use a : as a separator, not a .

[bibblebub]

chuck is right, no need to use the time() function

[ChuckFickens]

Using the time function seems long winded when 23:57:21 would do the same thing.

[Old_Geezer]

Dates or time ?
I like to 'play' with the custom category, get it exactly as you want.

[ChuckFickens]

BTW, if you're wondering why it's happening it's due to how excel stores times internally. It stores time as a fraction of one, so 6am is stored as .25 (1/4 of 24hours) and 6pm is stored as .75 (3/4 of 24hours)

When you enter 16.30 the initial 16 is ignored as you've only formatted the cell for time (if you used a date format it would count it as 16days) and the .30 is interoperated as 7:12 which is 3/10 of 24

[rojash]

Aren't you afraid that they are out to kill you Chuck?

[anotheoldgit]

Thank you all for your answers.

Wow Chuck don't they make it complicated, it makes one wonder why they have all those different number formats, when one can just type them out, just as you so kindly suggested.