Thread: Why are sometimes seconds not shown in cell? timestamp format problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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


Reply With QuoteReply With Quote