Converting UTC timestamp value to date and time

S

SK

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GMT(UTC) date Storage Retrieval Questions 4
date/time field converting UTC to default timezone 4
Why are sometimes seconds not shown in cell? timestamp format problem 1
HELP: Adding data from Cells B1, B2, B3 etc. into COL F every other12 rows. 16
Converting Date & Time between time zones 7
UTC time to standard time 3
Elapsed Time returned from query 1
Time averaging raw data 3

Top