How to display duration field value in a proper format in an excel report

Johannes Mweli
Giga Guru

‎01-08-2020 07:30 AM

Hi ServiceNow Community Developers,

I have a very simple report running on the incident table and has a duration field in it. When I look at the report in the ServiceNow platform it looks good, the duration field value is displaying as expected with the proper format. However when I download it into spreadsheet the value of "3 Days 21 Hours 1 Minute" for instance that I see in the duration field inside the ServiceNow platform gets displayed as "334909" and I am not show why.  

Would you guys please advise as to how can I overcome this issue when downloading a report that has duration field into a spreadsheet. Basically in the spreadsheet I would like to see the same value as I see in the report inside ServiceNow.

Thanks,

Johannes

0 Helpfuls
  • 2,998 Views
5 REPLIES 5

Johannes Mweli
Giga Guru

‎01-10-2020 12:39 PM

Hi JeffCsn,

Thanks a lot for all your input / suggestions. I noticed that when I download the same report as a PDF it works as expected i.e. it takes the display value of the duration field rather the actual value. I therefore advised my user to go with that option instead. I will definitely give the formula you provided here a try.

Johannes

0 Helpfuls