excel - How can I generate a .xlsx time-tracking report with my .ics file exported from iCal? -

Time Tracking Report (.xlsx or .csv) is required to generate AG: < Pre BEGIN_DATE, BEGIN_Time, END_Date, END_Time, SUB_TOTAL hours, TOTAL_MH, TOTAL_HTD

Key: MH, Monthly Hours HTD, Hours to Date

Using the exported data from .ics file:

[example]

  BEGIN: Texture created: 20130527 T32646Z UID: 78AAAEC5-8DA5-4E33-8B50 -74C95763C17D DTEND; VALUE = Date: 20131110 TRANSP: TRANSPARENT SUMMARY: [EVENT_NAME_HERE] DTSTART; VALUE = Date: 20131109 DTSTMP: 20130527 T32652Z Sequence: 2 End VEVENT    
 
 
 cell A1 Paste your code snippet into a new Excel file; Cell A2 should contain 'CREATED: 20130527T032646Z'  
 Use the following formula to extract the date value in cell B2: cell A2 will contain 'CREATED: 20130527T032646Z'  
 In Cell B2:  <":">  = IFERROR (DATEVALUE (Middle (MID (A2, Search (former, A2,1) +1,8), 5,2) & amp; "-" & amp; rights MID (A2, Search (":", A2,1) +1,8), 2) & amp; amp; & amp; amp; & amp;; & amp; nbsp; (MID (A2, Search (":", A2,1) +1, 8), 4)), "")   
 To remove the time limit, use the following formula in cell C2:  
  = IFERROR (TIMEVALUE (Mid (A2, (Search ("T", A2, Search (":", A2,1) +1)), 9), 2, 2) & amp; ":" & Middle MID (A2, Search ("T", A2, Lost (":", A2,1) +1)), 9), 4,2) & amp; ":" & amp; Middle (MID (A2, (Search ("T", A2, Search (": ' Remember to change the date and time cells in the date and time format by using 'format.' Cell. '