software

Is it possible to format a cell to represent time to six decmial places.
Example HH:MM:SS.123456

you can format the cell as quot;hh:mm:ssquot;, if that is what you mean.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;GregOquot; gt; wrote in message
...
gt; Is it possible to format a cell to represent time to six decmial places.
gt; Example HH:MM:SS.123456
If you convert each time element to text and format each one you can get a 6
position second display.

The following functions picks up the time in cell A1 and converts it to text
with the formatting needed:

=TEXT(HOUR(A1),quot;#quot;)amp;quot;:quot;amp;TEXT(MINUTE(A1),quot;0#quot;)amp;quot;:quot;amp; TEXT(SECOND(A1),quot;000000quot;)
--
Kevin Backmannquot;GregOquot; wrote:

gt; Is it possible to format a cell to represent time to six decmial places.
gt; Example HH:MM:SS.123456