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!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...