Spreadsheet: 777502d1650439058-get-all-values-from-a-column-were-first-to-characters-are-ii-and-put-in-consecutive-rows-sample
Sheet: Sheet1

Task | Job | Start date | Start time | End time | End date | Status | Duration (sec) | Runtime (Minutes) | Runtime (Hours) | Comment
II004: GL Interface - Cshbk/hsng/trfmn/rsc/cyb/lic/arpt | 003_Z_FI_D_II:GL_II004 | 42523 | 19:11:03 | 19:11:29 | 42523 | Finished | 26 | 0.4 | 0
Time Evaluation | 005_Z_HR_D_J_TIME_EVAL | 42524 | 00:01:04 | 00:53:11 | 42524 | Finished | 3127 | 52.1 | 0.9
MRP Daily Report | 006_Z_MM_D_J:MRP_REPORT | 42523 | 19:11:03 | 19:16:23 | 42523 | Finished | 320 | 5.3 | 0.1
MRP Daily | 007_Z_MM_D_J:MRP | 42523 | 19:16:24 | 19:16:32 | 42523 | Finished | 8 | 0.1 | 0
II221: Update of ref numbers from Coll Agencies: SDJ/TAF/VVM | 011_Z_FICA_M_II:[NAME] | 42523 | 19:11:02 | 19:11:03 | 42523 | Finished | 1 | 0 | 0
RMPM Device Plan | 012_Z_RMPM_D_J:BFR_DEVICE_PLAN | 42523 | 19:11:02 | 19:13:56 | 42523 | Finished | 174 | 2.9 | 0
II241: Update of Legal Status from Coll Agencies | 015_Z_FICA_W_II:UPD_LEG_CA_II241 | 42523 | 19:11:03 | 19:11:04 | 42523 | Finished | 1 | 0 | 0
OI233: Clearance Certificate Report | 018_Z_R_D_OI:CLEAR_CERTREP_OI233 | 42523 | 19:11:03 | 19:11:06 | 42523 | Finished | 3 | 0 | 0
II212: GIS Valuations Interface | 021_Z_R_D_II:VALTN_II212 | 42523 | 19:11:03 | 19:12:22 | 42523 | Finished | 79 | 1.3 | 0
RMPM PayTrans Plan | 022_Z_RMPM_D_J:BFR_PAYTRANS_PLAN | 42523 | 21:00:02 | 21:03:27 | 42523 | Finished | 205 | 3.4 | 0.1
OI215: Customer/Contact Download: ESS | 024_Z_SD_D_IOI:ESS_OI215 | 42523 | 19:11:03 | 19:11:05 | 42523 | Finished | 2 | 0 | 0
OI215: Customer/Contact Download: Cashbook | 025_Z_SD_D_IOI:CSHBK_OI215 | 42524 | 06:00:09 | 06:00:10 | 42524 | Finished | 1 | 0 | 0
[NAME] Payment Transfer Lot | 026_Z_FICA_D_II:BPLT_TRNSF_II231 | 42523 | 19:11:06 | 19:26:01 | 42523 | Finished | 895 | 14.9 | 0.2
II005002: ESS to SAP: Ess to Sap | 027_Z_SD_D_II:ESS_II005002 | 42523 | 19:11:07 | 19:11:07 | 42523 | Finished | 0 | 0 | 0
BW Trigger | 028_Z_BW_D_J:TRIGGER_BW | 42523 | 20:20:01 | 20:20:01 | 42523 | Finished | 0 | 0 | 0
II207: Create IDOC for MR Upload: Manmum&MeterTrack | 032_Z_DM_D_II:MANM_II207 | 42523 | 19:11:03 | 19:16:55 | 42523 | Finished | 352 | 5.9 | 0.1
[NAME] | 033_Z_DM_D_J:UPLD_MR | 42523 | 19:16:56 | 19:29:46 | 42523 | Finished | 770 | 12.8 | 0.2
Correct Implausible Readings | 034_Z_DM_D_J:CORR_IMPL_RDGS | 42523 | 19:29:47 | 19:55:03 | 42523 | Finished | 1516 | 25.3 | 0.4
II208: Upload from IBIS | 035_Z_DM_D_II:IBIS_II208 | 42523 | 19:11:04 | 19:19:27 | 42523 | Finished | 503 | 8.4 | 0.1
II218: Action File from UMS | 036_Z_FICA_D_II:UMS_II218 | 42523 | 21:14:24 | 21:26:51 | 42523 | Finished | 747 | 12.4 | 0.2
Mass Estimation | 038_Z_DM_D_J:MASS_EST | 42523 | 19:55:04 | 20:13:22 | 42523 | Finished | 1098 | 18.3 | 0.3
Result should be as below
Inbound Interfaces
II004: GL Interface - Cshbk/hsng/trfmn/rsc/cyb/lic/arpt
II221: Update of ref numbers from Coll Agencies: SDJ/TAF/VVM
II241: Update of Legal Status from Coll Agencies
II212: GIS Valuations Interface
[NAME] Payment Transfer Lot
II005002: ESS to SAP: Ess to Sap
II207: Create IDOC for MR Upload: Manmum&MeterTrack
II208: Upload from IBIS
II218: Action File from UMS