QueueMetrics professional call center suite for the Asterisk PBX
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Welcome to the new forum!
Home
Help
Search
Login
Register
QueueMetrics forum
»
QueueMetrics
»
Running QueueMetrics
»
Error formating time when export to excel
« previous
next »
Print
Pages: [
1
]
Author
Topic: Error formating time when export to excel (Read 2201 times)
cesar.bonilla
Newbie
Posts: 5
Karma: 0
Error formating time when export to excel
«
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,
Logged
QueueMetrics
Loway
Hero Member
Posts: 2999
Karma: 39
Re: Error formating time when export to excel
«
Reply #1 on:
August 09, 2011, 10:14:36 »
Please inspect the CSV file Qm generates ans check what is written there.
Logged
cesar.bonilla
Newbie
Posts: 5
Karma: 0
Re: Error formating time when export to excel
«
Reply #2 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,
Logged
QueueMetrics
Loway
Hero Member
Posts: 2999
Karma: 39
Re: Error formating time when export to excel
«
Reply #3 on:
August 10, 2011, 11:20:49 »
Logged
Print
Pages: [
1
]
« previous
next »
QueueMetrics forum
»
QueueMetrics
»
Running QueueMetrics
»
Error formating time when export to excel