Feasibility to download the data for the duration field in days hours mins secs format instead of ms

[Arka Banerjee]

Hi All,

Is there any way by which we can get the data in the same format that we do in the list view of any SNOW table?

Whenever I download it, it downloads the same in milliseconds(sn_hr_core_case_workforce_admin_list table in my case, even though I believe its not relevant). Would like to have the same format retained as in the screenshot when its export to excel as per client requirement.

[J Siva]

Hi @Arka Banerjee 
That's the expected behavior of the Duration type fields.
As a workaround, create one read-onlt strig type field and store the duration value.
For more details, chcek out the below community post.
https://www.servicenow.com/community/itsm-forum/after-export-as-excel-time-fields-are-showing-second...

Regards,
Siva

[Ankur Bawiskar · Accepted solution]

@Arka Banerjee 

that's expected behavior and you cannot change it.

I shared an approach in this link, see below

After export as Excel time fields are showing seconds but i want to see it in only Hours and Minutes 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Arka Banerjee 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Arka Banerjee 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.