topic Convert decimal date time value in CSV export in Excel in Other Usage

Convert decimal date time value in CSV export in Excel

mrpaul — Fri, 05 Jan 2024 14:36:12 GMT

I have a CSV export from splunk, and two of the columns are timestamps. Both were converted to human-readable using convert ctime(fieldname) in the splunk query, and show as decimal numbers in the CSV file.

For example,

01/03/2024 12:49:48.192 is represented as 45294.5345855556 in the CSV file

How do I convert that decimal to a human-readable timestamp in Excel?

Thanks!

Re: Convert decimal date time value in CSV export in Excel

ITWhisperer — Fri, 05 Jan 2024 19:09:47 GMT

This is really an Excel question rather than a Splunk question. In Splunk, date-times are stored internally as the number of seconds since 1/1/1970, whereas in Excel, date-times are stored internally as the number of days since 1/1/1900 (I think). Just format the cell as a date in Excel.