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 Answers Content Calendar, June Edition

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

What You Read The Most: Splunk Lantern’s Most Popular Articles!

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

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...