Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i convert a number of seconds to a date/time?
I have some system logs that have a number that is either a serial number or
the number of seconds. I have tried to use the Convert function, format the cell to date/time, but it doesn't look reasonable. I've read that serial numbers start at 1/1/1900, but this would put my date/time at september 2005, and we aren't there yet. :) Any suggestions and ideas would be helpful. |
#2
|
|||
|
|||
Margo,
Time is stored as a fraction of 1 day, dates as the number of date from 01/01/1900. Today, 9:00PM has a value of 38,356.88. If your number is in seconds, divide it by 86,400 (24*60*60) to get a date/time number. -- HTH RP (remove nothere from the email address if mailing direct) "Margo" wrote in message ... I have some system logs that have a number that is either a serial number or the number of seconds. I have tried to use the Convert function, format the cell to date/time, but it doesn't look reasonable. I've read that serial numbers start at 1/1/1900, but this would put my date/time at september 2005, and we aren't there yet. :) Any suggestions and ideas would be helpful.88 |
#3
|
|||
|
|||
Do you have an example number and the approximate date/time that it should
represent? Tim C "Margo" wrote in message ... I have some system logs that have a number that is either a serial number or the number of seconds. I have tried to use the Convert function, format the cell to date/time, but it doesn't look reasonable. I've read that serial numbers start at 1/1/1900, but this would put my date/time at september 2005, and we aren't there yet. :) Any suggestions and ideas would be helpful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Convert week number into calendar month? | Excel Worksheet Functions | |||
How do I convert 300616a to show as a number 303616? | Excel Worksheet Functions |