Other Usage

Convert decimal date time value in CSV export in Excel

mrpaul
Explorer

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!

Labels (1)
Tags (3)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

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.

Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...