Ability to create and export custom reports
- Add an option to export custom reports with time fields (such as call duration, agent handle time, etc.) formatted explicitly as
hh:mm:ss
(hours:minutes:seconds). - Ensure this format is consistent across both CSV and Excel exports, allowing for accurate time analysis and easy integration with other tools and workflows.
- Where relevant, support extended formats like
[h]:mm:ss
for durations exceeding 24 hours, as commonly used in timesheet and workforce data exports.
Rationale:
- The
hh:mm:ss
format is widely recognized and supported by both Excel and CSV parsers, ensuring that time values are correctly interpreted and easily manipulated in downstream analysis. - Many organizations rely on precise time tracking for reporting, billing, and compliance. A standardized export format will reduce manual data cleaning and improve reporting accuracy.
- Other platforms exporting timesheet or duration data (e.g., Deputy, Microsoft Power BI integrations) already support this format, allowing for smoother data consolidation and comparison.
Additional Notes:
- If possible, allow users to select their preferred time format (e.g.,
hh:mm:ss
,[h]:mm:ss
, or decimal hours) during the export process to accommodate different reporting needs. - Ensure that exported time fields are not auto-converted to date/time values by Excel unless intended, preserving the original duration format for accurate calculations.
1
vote
