| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting UTC timestamp value to date and time
I have downloaded 5-minute-interval stock data from a data-vendor into CSV
format for display and charting in Excel. However, the date and time are in UTC timestamp value (in 10 digits) which is the number of seconds elapsed since 00:00 hours on Jan 1, 1970 UTC. I need to convert them into Excel's date and time format. Would someone help as I could not figure out how to do it properly with Excel functions? Your help is greatly appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting UTC timestamp value to date and time
See
http://www.mcgimpsey.com/excel/udfs/unixtoxltime.html In article , SK wrote: I have downloaded 5-minute-interval stock data from a data-vendor into CSV format for display and charting in Excel. However, the date and time are in UTC timestamp value (in 10 digits) which is the number of seconds elapsed since 00:00 hours on Jan 1, 1970 UTC. I need to convert them into Excel's date and time format. Would someone help as I could not figure out how to do it properly with Excel functions? Your help is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Elapsed time: difference between 2 Date/Timestamp perio | Excel Worksheet Functions | |||
| synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
| converting general text to date time | Excel Discussion (Misc queries) | |||
| Convert Unix timestamp to Readable Date/time | Excel Worksheet Functions | |||
| converting text in cell to a date time | Excel Worksheet Functions | |||
Linear Mode
