QueueMetrics > Running QueueMetrics

Error formating time when export to excel

(1/1)

cesar.bonilla:
Hi,

When I try to export the answered calls to excel, the duration time and waiting time are shown with date format:

MM:ss ->  12:MM:ss

For example, 0:16, 0 minutes and 16 seconds, in excel is 12:00:16 am.

Thanks in advance,

QueueMetrics:
Please inspect the CSV file Qm generates ans check what is written there.

cesar.bonilla:
In CSV file, the time format is HH:MM:SS. the format is not interpretable from excel. When import with openoffice, time format is OK.

Thanks,

QueueMetrics:
 ;D

Navigation

[0] Message Index

Go to full version