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 "hh:mm:ss", if that is what you mean.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"GregO" wrote in message
...
Is it possible to format a cell to represent time to six decmial places.
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),"#")&":"&TEXT(MINUTE(A1),"0#")&":"& TEXT(SECOND(A1),"000000")
--
Kevin Backmann


"GregO" wrote:

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