Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel dates work on a similar principal, but they measure day in terms
of a reference date of 31st December 1899 (day 0), so you will have to add the number of days that your reference date represents in Excel. Enter 1/1/70 into a cell and format it as a number - this will show you that it represents 25569 days, so this is what you will have to add to your elapsed days to make it into Excel dates. Times are represented as fractions of a 24 hour day, so to convert your seconds you will have to divide by 60, by 60 again and by 24. So, if your timestamp is in cell A1, this formula in B1 should do the trick: =A1/60/60/24 + 25569 Format the cell as Date in the appropriate style. Hope this helps. Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |