Why are sometimes seconds not shown in cell? timestamp format problem
 

I have a column in Excel which contain timestamp information.
When I right click on all the cells the format is

Number-Custom-TT.MM.JJJJ hh:MM

Much to my surprise some of the cells show a value of e.g.

00.01.1900 13:30

At first there are TWO (!) blanks between date and time.

Why?

Furthermore the seconds are not shown.

Why?

I expected (at least) "00".

Claudia

Why are sometimes seconds not shown in cell? timestamp format problem
 

Are you sure that your format wasn't
TT.MM.JJJJ hh:MM
rather than
TT.MM.JJJJ hh:MM ?

If you want seconds, what happens if you change it to TT.MM.JJJJ hh:MM:ss ?
--
David Biddulph


Claudia d'Amato wrote:
I have a column in Excel which contain timestamp information.
When I right click on all the cells the format is

Number-Custom-TT.MM.JJJJ hh:MM

Much to my surprise some of the cells show a value of e.g.

00.01.1900 13:30

At first there are TWO (!) blanks between date and time.

Why?

Furthermore the seconds are not shown.

Why?

I expected (at least) "00".

Claudia