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!
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.