Cell formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format CONCATENATE 3
Converting decmials to factions 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Can I stop rounding in excel? 5
Shortcut for current Time in hh:mm:ss 2
MROUND time 2
Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss ) 8
Format Number 3

Back
Top