Reporting Excel extracts for Date, Date-Time, and Time fields are exporting in numeric seconds

[shubhangigophan]

Date, Date-Time, and Time fields are all exported as their display values, displayed using a custom format instead of the system date format. Duration fields, however, export as the value stored in the database, which is an integer value of seconds.

- Duration

- Aging Time Open

- Actual elapsed time

- etc

Important Note:

Known ServiceNow Issue and eventually there "may" be a fix eventually per ServiceNow Cag Onganer:

Can we fix this with the help of metric?

[vishal065]

Hi Shubhangi,

You might get some help from below thread.

Need Duration in Minutes rather than Seconds

Regards

Vishal

[vishal065 · Accepted solution]

Also refer following threads.

Exported report is showing values in seconds

Duration field Reporting Format change  

[shubhangigophan]

Thank you Vishal. It is helpful