Software

Ask something
Question Locked

Exporting reports from Shoretel to Excel.

0 helpful
3 replies

by dsullivan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to export a report from Shoretel's Data Manament console to excel for comparisson to other in-house stats. No matter what option I use (export to excel, CSV, etc) the (elapsed) time fields do not import as a value but as text which, even after formatting the cells in Excel, cannot be used in calculations. (I tried specifiing the field as "time" but that creates a time stamp rather than elapsed time. I need to use these numbers in formulas without reentering the data affected.

3 replies

by dr dij

then some character in the field is causing this. Open the file in WORD or notepad.
(straight from shortell, not a copy saved from excel)

either quotes or maybe commas to separate thousands are keeping excel from seeing as anumber.

you can write a short vb function to parse the file and out put another corrected .csv.

by dsullivan

That really worked thanks. I do have one other question regarding formatting in Excel. I would like to show a VALUE of xhours, xminutes, xseconds as xx:xx:xx. But when I follow MS Excel help it says to format cells > custom > [hh]:mm:ss. It works and calculations have been accurate but if you select a cell with the value of 05:30:00 (representing 5 hr, 30 minutes, the formula shows 5:30 AM! (Time of day rather than amount of time). Any ideas?

This discussion is closed to new replies.