Author Topic: Error formating time when export to excel  (Read 2200 times)

cesar.bonilla

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
    • View Profile
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,

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
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.

cesar.bonilla

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
    • View Profile
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,

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Error formating time when export to excel
« Reply #3 on: August 10, 2011, 11:20:49 »
 ;D