duration type field is showing integer value instead of display value while exporting to excel

Balakrishna_ABK · ‎02-15-2024

duration field exporting as the value stored in the database, which is an integer value of seconds. How to convert into HH:MM:SS format ?

Dr Atul G- LNG · ‎02-15-2024

Hi @Balakrishna_ABK

Look like its OOTB of excel, you want it on SN or excel?

Go to excel

right click on cell - number format and select

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Dr Atul G- LNG · ‎02-15-2024

Hi @Balakrishna_ABK

https://www.servicenow.com/community/developer-forum/how-to-convert-second-into-hours/m-p/2181264

https://www.servicenow.com/community/developer-forum/convert-seconds-to-duration/m-p/1591318

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************