Export Usage History into Excel?

[ute1978]

I don't know if this has been suggested yet, but I would like to suggest the possibility to export the Usage History into an Excel sheet so we can sort the columns "Call Type" and/or "Usage Types".

Thanks.

[mpfc75]

Hey PM!  Do you have any feedback for us on this idea?  Are you considering it?

[paulie]

+1 and invoice in downloadbale format in PDF or CSV format friendly.

[jpar]

I would really like to see this implemented.

[marsbar]

I have built a custom date formatting VBA code if anyone is interested to convert PublicMobile date format into Excel format; but do note that it ignores the Hours and Minutes of a date stamp. Note that I built this in Excel 2007 so it may or may not work for later versions of Excel.

Public Function convertDate(text As String) As Date
Dim DateArray() As String
DateArray = Split(text, "/")
DayPart = DateArray(0)
MonthPart = DateArray(1)
YearPart = Left(DateArray(2), 4)
Select Case MonthPart
Case "01", "1"
    mon = "Jan"
Case "02", "2"
    mon = "Feb"
Case "03", "3"
    mon = "Mar"
Case "04", "4"
    mon = "Apr"
Case "05", "5"
    mon = "May"
Case "06", "6"
    mon = "Jun"
Case "07", "7"
    mon = "Jul"
Case "08", "8"
    mon = "Aug"
Case "09", "9"
    mon = "Sep"
Case "10"
    mon = "Oct"
Case "11"
    mon = "Nov"
Case "12"
    mon = "Dec"
End Select
convertDate = CDate(DayPart & " " & mon & " " & YearPart)
End Function

You can then call it in your cell as the formula =convertDate(A62)