Workforce Engagement Management

Hello,

I was searching on the community about the duration format in the historical adherence export. I've seen that it is in numerical format by design and it is intended to be like that. Anyway, we were wondering if it could be a setting on the export options like in the other Analytics reports. Our customer would appreciate the format export in HH:MM:SS or at least with Europe locale where the decimal separator is the comma ",". The current format with the "." as a separator is causing a lot of issue in the excel rework and data presentation.

Thank you,

Alexandra

I would suggest opening an Idea on our Ideas Lab: https://genesyscloud.ideas.aha.io/ideas

Excel can most likely get you what you want. As long as the person using Excel has a locale that is consistent with the export's decimal separator (i.e., both use decimal comma or decimal point), the Excel will handle the separator appropriately given (at least with the two below I use as an example). 

5d 15h 13m 30s format: 

=INT($E2/1440)&"d " &
INT(MOD($E2,1440)/60)&"h " &
INT(MOD($E2,60))&"m " &
ROUND(MOD($E2*60,60),0) &"s"

=TEXT($E1/1440,"[h]:mm:ss")