Cell formatting

[GregO]

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

[Bob Phillips]

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" <GregO@discussions.microsoft.com> wrote in message
news:22AF39D1-170C-445B-90D0-97DF585B06C4@microsoft.com...
> Is it possible to format a cell to represent time to six decmial places.
> Example HH:MM:SS.123456

[Kevin B]

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