How can i convert tenths of a second to time (Hours, min,sec ). Can this happen with macro..?
P Pape Dec 16, 2004 #1 How can i convert tenths of a second to time (Hours, min,sec ). Can this happen with macro..?
F Frank Kabel Dec 16, 2004 #2 Hi try the following formula =A1/(24*60*60*10) and format the resulting cell as time