If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Converting Time
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: Befo 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 |
#2
|
|||
|
|||
Converting Time
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---" wrote in message ... 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: Befo 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 |
#3
|
|||
|
|||
Converting Time
Hello Peo,
That worked very well! Thanks! Francis -----Original Message----- 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---" wrote in message ... 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: Befo 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 . |
Thread Tools | |
Display Modes | |
|
|