QueueMetrics forum

QueueMetrics => Running QueueMetrics => Topic started by: cesar.bonilla on August 01, 2011, 18:34:23

Title: Error formating time when export to excel
Post by: cesar.bonilla on August 01, 2011, 18:34:23

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,

Title: Re: Error formating time when export to excel
Post by: QueueMetrics on August 09, 2011, 10:14:36

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

Title: Re: Error formating time when export to excel
Post by: cesar.bonilla on August 09, 2011, 18:35:12

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,

Title: Re: Error formating time when export to excel
Post by: QueueMetrics on August 10, 2011, 11:20:49

 ;D