| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert second to date and time
Hi,
i've got some exported log from unix platform. in those logs, time and date is written as lapsed second since 01.01.1970. How can i extract date and time from this lapsed second since 01.01.1970. e.g : 1165391099.763 thanks a lot, Al. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help: convert seconds to date and time | Excel Discussion (Misc queries) | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| convert interval to various separate date , time, hr, minutes | Excel Worksheet Functions | |||
| Convert date to length of time in months from set date | Excel Worksheet Functions | |||
| how do I convert a date and time column to a time column | Excel Worksheet Functions | |||
Threaded Mode
