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

C

Claudia d'Amato

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
 
D

David Biddulph

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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

format time problem 5
Format problem in displayed userform 8
conditional number format dependent on other cell 2
The same Date / Time field contains time in different format after import from text file 4
Time Format 6
Averaging times that are not in a range 4
I need to math manipulate figs over 10,000( in hrs & min format)? 2
Format Cell As You Type 4

Top