Converting Time

[---Francis---]

Hello,

I am using MS Excel 2000. I have a cell that displays a
number in seconds. The number is rather large and it
would be useless to show this time in seconds. I would
like to have Excel show this cell using minutes, seconds,
and, /1000 seconds.

ie: Before: 2264.125 <---- total number of seconds
After: 37:44.125 <---- 37m 44s 125/1000s

I have tried using some of the time formating in
the "Cells" -> "Format" menu, but can't get anything to
work.

Thanks in advance,

Francis

 

[Peo Sjoblom]

Divide by 86400 (/24/60/60)and format as hh:mm:ss.000

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Francis]

Hello Peo,

That worked very well! Thanks!

Francis