Unusual timestamp value in rollup Excel report

[iperry]

Heya,

I have created an Excel rollup report but I haven't figured out what the value for the timestamp is. It appears to be an incrementing value but what it means I don't know.

The values in the report are:

The timestamp appears to be incrementing by 0.000694444

The setup for the report is:

Any ideas/suggestions? I had expected a timestamp instead of a incrementing value.

Thanks
Ian

[JoelHaggar]

That's excel formatting the timestamp strange. The secret to getting Excel to keep the right format is to put in at least two rows of values and get the timestamp and values formatted the way you want. This way when the report runs the format you specified in your template will be used.

[iperry]

Hi @JoelHaggar

Ahh, Excel my nemesis, we meet again :P

Thanks for the suggestion. I added 2 rows to the report template and the export is now working as I would expect.

Ian