When you export to Excel, is that number listed in the Duration field in second, minutes? Any further insight would be super helpful

[Elaine Bucci]

Thank you I am just attempting to determine the duration from open to close of 5000+ cases

[Community Alums · Accepted solution]

Hi @Elaine Bucci ,

Duration field (the Actual elapsed time column) is formatted as Days, Hours, Minutes (e.g. 838 Days 19 Hours 46 Minutes). This is the expected behavior.

If you want to change or customize anything , here is mentioned couple of ways:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0656030

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Community Alums]

can you share the formula? i cant open the KB article

[rency vanathy2]

Hi Sandeep, 

can you share the formula? i cant open the KB article

[Elaine Bucci]

Thank you ---This is exactly what I needed ---THANK YOU!!!!