Is it possible to format a cell to represent time to six decmial places. Example HH:MM:SS.123456
G GregO Feb 21, 2006 #1 Is it possible to format a cell to represent time to six decmial places. Example HH:MM:SS.123456
B Bob Phillips Feb 21, 2006 #2 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)
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)
K Kevin B Feb 21, 2006 #3 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")
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")
