| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to specific "minutes:seconds" in cell format | Excel Discussion (Misc queries) | |||
| How do I format a cell for 00:00:00 (minutes:seconds:100th)? | Excel Discussion (Misc queries) | |||
| Format a cell so that if a 7 is entered it is shown as 07:00:00 | Excel Worksheet Functions | |||
| mySQL timestamp to readable format | Excel Discussion (Misc queries) | |||
| how do I format a cell to display in degrees minutes seconds | Excel Worksheet Functions | |||
Threaded Mode
