Converting Time

  • Thread starter Thread starter ---Francis---
  • Start date Start date
F

---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
 
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
 
Back
Top