How to create and assign a Custom Format of date and time to an entire column in excel worksheet

Question

Hi, I want a customized format(with milliseconds also) in such a way to handle for a date and time in Microsoft Excel.

Sample date and time: 08.25.2010 00:52:09.359

For understanding of above sample date time, it is 25th August 2010 12 hrs 52mins 9seconds 359 milliseconds(AM).

Please provide a custom Format to handle the above mentioned sample date and time and finally to apply for a column.

Answer 1

In Excel 2003 I use the following for time with fractions of second:

"hh:mm:ss,000" (note: my decimal point is a "," - German)

so a time entered as 12:13:14,1516 will be displayed as 12:13:14,152

Hope this works for you