Reports exported to Excel must show Hrs/Min/Seconds (S)

[doanh]

I have a issue when reports exported to Excel with date/time fields

this is a report

when i export to excel i received:

you can see the difference of date/time fields in both images

Question is how to be able to export the file to excel format and have date/time fields display in Hours/Minutes/Seconds instead of having the spreadsheet display in seconds   ? Do you have any approach in script ?

(note: this is not a bug of ServiceNow because this is a design by them )

[Melghi]

Hi,

That's a duration field.

Best way to manage this is to create another string field on your table that contains a calculated value from your actual elapsed time field.

[Melghi]

This is what I meant by calculated value

[doanh]

Hi Mohamed ,

thank for your answer, but you know, our users have to choose a lot of table and export report (not a specific table ) .

so i seemly don't know how many fields i have to create.

Do you have another solution ?

Thank you,

[Melghi]

Hi,

The known problem concerns that type of field so it shouldn't be everywhere, however, you need to check your reports at least once when you extract them so that you can have a good view about it.