G Guest Dec 16, 2004 #1 How can i convert tenths of a second to time (Hours, min,sec ). Can this happen with macro..?
G Guest Dec 16, 2004 #2 Hi try the following formula =A1/(24*60*60*10) and format the resulting cell as time
R R.VENKATARAMAN Dec 16, 2004 #3 try custom format [h]:mm:ss.0 if not available introduce it. you will get for e.g. 10:13:12.5 is this what you want
try custom format [h]:mm:ss.0 if not available introduce it. you will get for e.g. 10:13:12.5 is this what you want
