Spreadsheet: 385435d1427303367-find-time-taken-by-member-relocationlist_test
Sheet: RelocationList 1 

 | Item ID | Version No. | [NAME] | File Name |  | Modified Date | Modified By |  | Title
 | 5 | 20 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-07 05:05:58 | Nidhi Sharma 5 |  | DeepakGoyal1088011.xml | Please help me to solve this problem as I want to find time taken by member.
 |  | 19 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 10:01:40 | Praduman [NAME] |  | DeepakGoyal1088011.xml | In case: I have done manually. Like I minus the date of member from created date(yellow color).
 |  | 18 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 09:47:38 | Praduman [NAME] |  | DeepakGoyal1088011.xml | And on next sheet(Sheet1) I want time should be come below their name.
 |  | 17 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 09:47:34 | Praduman [NAME] |  | DeepakGoyal1088011.xml | Column G is insteaded by me
 |  | 16 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 09:47:26 | Praduman [NAME] |  | DeepakGoyal1088011.xml
 |  | 15 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 05:05:19 | Tarun Dixit |  | DeepakGoyal1088011.xml
 |  | 14 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 05:05:14 | Tarun Dixit |  | DeepakGoyal1088011.xml
 |  | 13 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 05:00:57 | [NAME] |  | DeepakGoyal1088011.xml
 |  | 12 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 05:00:55 | [NAME] |  | DeepakGoyal1088011.xml
 |  | 11 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 03:24:33 | [NAME] |  | DeepakGoyal1088011.xml
 |  | 10 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 03:24:25 | [NAME] |  | DeepakGoyal1088011.xml
 |  | 9 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 03:24:25 | [NAME] |  | DeepakGoyal1088011.xml
 |  | 8 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 03:24:20 | [NAME] |  | DeepakGoyal1088011.xml
 |  | 7 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 03:24:19 | [NAME] |  | DeepakGoyal1088011.xml
 |  | 6 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 03:24:19 | [NAME] |  | DeepakGoyal1088011.xml
 |  | 5 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 03:23:58 | [NAME] |  | DeepakGoyal1088011.xml
 |  | 4 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-04 03:23:52 | [NAME] |  | DeepakGoyal1088011.xml
 |  | 3 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-03 12:00:51 | [NAME] 2 |  | DeepakGoyal1088011.xml
 |  | 2 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-03 11:59:38 | [NAME] 2 |  | DeepakGoyal1088011.xml
 |  | 1 |  | DeepakGoyal1088011.xml | 2014-11-03 11:59:07 | 2014-11-03 11:59:07 | [NAME] 2 |  | DeepakGoyal1088011.xml
 | 6 | 8 |  | VisheshChopra1103076.xml | 2014-11-03 17:24:06 | 2014-11-07 05:03:24 | Nidhi Sharma 5 |  | VisheshChopra1103076.xml
 |  | 7 |  | VisheshChopra1103076.xml | 2014-11-03 17:24:06 | 2014-11-05 03:24:32 | Mohit Saraf |  | VisheshChopra1103076.xml
 |  | 6 |  | VisheshChopra1103076.xml | 2014-11-03 17:24:06 | 2014-11-04 05:38:31 | [NAME] |  | VisheshChopra1103076.xml
 |  | 5 |  | VisheshChopra1103076.xml | 2014-11-03 17:24:06 | 2014-11-04 05:09:07 | Tarun Dixit |  | VisheshChopra1103076.xml
 |  | 4 |  | VisheshChopra1103076.xml | 2014-11-03 17:24:06 | 2014-11-04 05:09:04 | Tarun Dixit |  | VisheshChopra1103076.xml
 |  | 3 |  | VisheshChopra1103076.xml | 2014-11-03 17:24:06 | 2014-11-04 04:15:23 | [NAME] |  | VisheshChopra1103076.xml
 |  | 2 |  | VisheshChopra1103076.xml | 2014-11-03 17:24:06 | 2014-11-04 04:15:13 | [NAME] |  | VisheshChopra1103076.xml
 |  | 1 |  | VisheshChopra1103076.xml | 2014-11-03 17:24:06 | 2014-11-03 17:24:06 | [NAME] 2 |  | VisheshChopra1103076.xml
 | 7 | 9 |  | MeenakshiYadav1102417.xml | 2014-11-03 17:35:28 | 2014-11-06 11:56:04 | Nidhi Sharma 5 |  | MeenakshiYadav1102417.xml
 |  | 8 |  | MeenakshiYadav1102417.xml | 2014-11-03 17:35:28 | 2014-11-05 03:23:59 | Mohit Saraf |  | MeenakshiYadav1102417.xml
 |  | 7 |  | MeenakshiYadav1102417.xml | 2014-11-03 17:35:28 | 2014-11-04 06:12:52 | [NAME] |  | MeenakshiYadav1102417.xml
 |  | 6 |  | MeenakshiYadav1102417.xml | 2014-11-03 17:35:28 | 2014-11-04 06:12:49 | [NAME] |  | MeenakshiYadav1102417.xml
 |  | 5 |  | MeenakshiYadav1102417.xml | 2014-11-03 17:35:28 | 2014-11-04 05:12:49 | [NAME] |  | MeenakshiYadav1102417.xml
 |  | 4 |  | MeenakshiYadav1102417.xml | 2014-11-03 17:35:28 | 2014-11-04 05:12:48 | [NAME] |  | MeenakshiYadav1102417.xml
 |  | 3 |  | MeenakshiYadav1102417.xml | 2014-11-03 17:35:28 | 2014-11-04 05:06:56 | Tarun Dixit |  | MeenakshiYadav1102417.xml
 |  | 2 |  | MeenakshiYadav1102417.xml | 2014-11-03 17:35:28 | 2014-11-04 05:06:54 | Tarun Dixit |  | MeenakshiYadav1102417.xml
 |  | 1 |  | MeenakshiYadav1102417.xml | 2014-11-03 17:35:28 | 2014-11-03 17:35:28 | [NAME] 2 |  | MeenakshiYadav1102417.xml
 | 8 | 9 |  | KartarSingh1102428.xml | 2014-11-03 17:44:21 | 2014-11-07 04:34:04 | Nidhi Sharma 5 |  | KartarSingh1102428.xml
 |  | 8 |  | KartarSingh1102428.xml | 2014-11-03 17:44:21 | 2014-11-04 10:28:52 | Mohit Saraf |  | KartarSingh1102428.xml
 |  | 7 |  | KartarSingh1102428.xml | 2014-11-03 17:44:21 | 2014-11-04 05:34:20 | [NAME] |  | KartarSingh1102428.xml
 |  | 6 |  | KartarSingh1102428.xml | 2014-11-03 17:44:21 | 2014-11-04 05:11:17 | Tarun Dixit |  | KartarSingh1102428.xml
 |  | 5 |  | KartarSingh1102428.xml | 2014-11-03 17:44:21 | 2014-11-04 05:10:45 | Tarun Dixit |  | KartarSingh1102428.xml
 |  | 4 |  | KartarSingh1102428.xml | 2014-11-03 17:44:21 | 2014-11-04 05:10:03 | Tarun Dixit |  | KartarSingh1102428.xml
 |  | 3 |  | KartarSingh1102428.xml | 2014-11-03 17:44:21 | 2014-11-04 05:09:59 | Tarun Dixit |  | KartarSingh1102428.xml
 |  | 2 |  | KartarSingh1102428.xml | 2014-11-03 17:44:21 | 2014-11-04 04:47:35 | [NAME] |  | KartarSingh1102428.xml
 |  | 1 |  | KartarSingh1102428.xml | 2014-11-03 17:44:21 | 2014-11-03 17:44:21 | [NAME] 2 |  | KartarSingh1102428.xml
 | 9 | 13 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-07 11:03:46 | Nidhi Sharma 5 |  | LakshayNagpal1102309.xml
 |  | 12 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-05 03:23:36 | Mohit Saraf |  | LakshayNagpal1102309.xml
 |  | 11 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-04 07:59:53 | Tarun Dixit |  | LakshayNagpal1102309.xml
 |  | 10 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-04 07:59:50 | Tarun Dixit |  | LakshayNagpal1102309.xml
 |  | 9 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-04 07:59:47 | Tarun Dixit |  | LakshayNagpal1102309.xml
 |  | 8 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-04 05:32:02 | [NAME] |  | LakshayNagpal1102309.xml
 |  | 7 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-04 05:31:55 | [NAME] |  | LakshayNagpal1102309.xml
 |  | 6 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-04 05:31:45 | [NAME] |  | LakshayNagpal1102309.xml
 |  | 5 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-04 05:17:47 | Tarun Dixit |  | LakshayNagpal1102309.xml
 |  | 4 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-04 05:17:45 | Tarun Dixit |  | LakshayNagpal1102309.xml
 |  | 3 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-04 04:32:09 | [NAME] |  | LakshayNagpal1102309.xml
 |  | 2 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-03 17:51:38 | [NAME] 2 |  | LakshayNagpal1102309.xml
 |  | 1 |  | LakshayNagpal1102309.xml | 2014-11-03 17:50:35 | 2014-11-03 17:50:35 | [NAME] 2 |  | LakshayNagpal1102309.xml
 | 10 | 11 |  | NishaSharma9364510.xml | 2014-11-03 17:59:50 | 2014-11-06 11:58:16 | Nidhi Sharma 5 |  | NishaSharma9364510.xml
 |  | 10 |  | NishaSharma9364510.xml | 2014-11-03 17:59:50 | 2014-11-04 07:14:12 | Praduman [NAME] |  | NishaSharma9364510.xml
 |  | 9 |  | NishaSharma9364510.xml | 2014-11-03 17:59:50 | 2014-11-04 05:12:53 | Tarun Dixit |  | NishaSharma9364510.xml
 |  | 8 |  | NishaSharma9364510.xml | 2014-11-03 17:59:50 | 2014-11-04 05:12:51 | Tarun Dixit |  | NishaSharma9364510.xml
 |  | 7 |  | NishaSharma9364510.xml | 2014-11-03 17:59:50 | 2014-11-04 05:11:33 | [NAME] |  | NishaSharma9364510.xml
 |  | 6 |  | NishaSharma9364510.xml | 2014-11-03 17:59:50 | 2014-11-04 04:49:49 | [NAME] |  | NishaSharma9364510.xml
 |  | 5 |  | NishaSharma9364510.xml | 2014-11-03 17:59:50 | 2014-11-04 04:48:40 | [NAME] |  | NishaSharma9364510.xml
 |  | 4 |  | NishaSharma9364510.xml | 2014-11-03 17:59:50 | 2014-11-04 04:48:13 | [NAME] |  | NishaSharma9364510.xml
 |  | 3 |  | NishaSharma9364510.xml | 2014-11-03 17:59:50 | 2014-11-04 04:47:52 | [NAME] |  | NishaSharma9364510.xml
 |  | 2 |  | NishaSharma9364510.xml | 2014-11-03 17:59:50 | 2014-11-04 04:47:45 | [NAME] |  | NishaSharma9364510.xml
 |  | 1 |  | NishaSharma9364510.xml | 2014-11-03 17:59:50 | 2014-11-03 17:59:50 | [NAME] 2 |  | NishaSharma9364510.xml
 | 11 | 17 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-07 05:08:46 | Nidhi Sharma 5 |  | NatashaKhapra10145711.xml
 |  | 16 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 06:03:24 | Praduman [NAME] |  | NatashaKhapra10145711.xml
 |  | 15 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 06:03:23 | Praduman [NAME] |  | NatashaKhapra10145711.xml
 |  | 14 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 06:03:22 | Praduman [NAME] |  | NatashaKhapra10145711.xml
 |  | 13 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 06:03:21 | Praduman [NAME] |  | NatashaKhapra10145711.xml
 |  | 12 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 06:03:19 | Praduman [NAME] |  | NatashaKhapra10145711.xml
 |  | 11 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 06:03:15 | Praduman [NAME] |  | NatashaKhapra10145711.xml
 |  | 10 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 05:14:59 | Tarun Dixit |  | NatashaKhapra10145711.xml
 |  | 9 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 05:14:56 | Tarun Dixit |  | NatashaKhapra10145711.xml
 |  | 8 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 04:54:11 | [NAME] |  | NatashaKhapra10145711.xml
 |  | 7 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 04:54:07 | [NAME] |  | NatashaKhapra10145711.xml
 |  | 6 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 04:01:24 | [NAME] |  | NatashaKhapra10145711.xml
 |  | 5 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 04:01:18 | [NAME] |  | NatashaKhapra10145711.xml
 |  | 4 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-04 04:01:12 | [NAME] |  | NatashaKhapra10145711.xml
 |  | 3 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-03 18:25:20 | [NAME] 2 |  | NatashaKhapra10145711.xml
 |  | 2 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-03 18:24:11 | [NAME] 2 |  | NatashaKhapra10145711.xml
 |  | 1 |  | NatashaKhapra10145711.xml | 2014-11-03 18:17:24 | 2014-11-03 18:17:24 | [NAME] 2 |  | NatashaKhapra10145711.xml
 | 12 | 9 |  | Pooja.11023812.xml | 2014-11-03 18:43:25 | 2014-11-07 04:57:10 | Nidhi Sharma 5 |  | Pooja.11023812.xml
 |  | 8 |  | Pooja.11023812.xml | 2014-11-03 18:43:25 | 2014-11-05 03:24:18 | Mohit Saraf |  | Pooja.11023812.xml
 |  | 7 |  | Pooja.11023812.xml | 2014-11-03 18:43:25 | 2014-11-04 06:06:55 | [NAME] |  | Pooja.11023812.xml
 |  | 6 |  | Pooja.11023812.xml | 2014-11-03 18:43:25 | 2014-11-04 05:16:16 | Tarun Dixit |  | Pooja.11023812.xml
 |  | 5 |  | Pooja.11023812.xml | 2014-11-03 18:43:25 | 2014-11-04 05:16:14 | Tarun Dixit |  | Pooja.11023812.xml
 |  | 4 |  | Pooja.11023812.xml | 2014-11-03 18:43:25 | 2014-11-04 05:16:12 | Tarun Dixit |  | Pooja.11023812.xml
 |  | 3 |  | Pooja.11023812.xml | 2014-11-03 18:43:25 | 2014-11-04 05:13:17 | [NAME] |  | Pooja.11023812.xml
 |  | 2 |  | Pooja.11023812.xml | 2014-11-03 18:43:25 | 2014-11-04 05:13:16 | [NAME] |  | Pooja.11023812.xml
 |  | 1 |  | Pooja.11023812.xml | 2014-11-03 18:43:25 | 2014-11-03 18:43:25 | [NAME] 2 |  | Pooja.11023812.xml
 | 13 | 17 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-11 11:55:16 | Praduman [NAME] |  | PankajLawania10635113.xml
 |  | 16 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-11 11:55:12 | Praduman [NAME] |  | PankajLawania10635113.xml
 |  | 15 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-11 11:55:10 | Praduman [NAME] |  | PankajLawania10635113.xml
 |  | 14 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-11 11:55:09 | Praduman [NAME] |  | PankajLawania10635113.xml
 |  | 13 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-11 11:55:09 | Praduman [NAME] |  | PankajLawania10635113.xml
 |  | 12 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-11 11:55:07 | Praduman [NAME] |  | PankajLawania10635113.xml
 |  | 11 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-07 04:37:34 | Nidhi Sharma 5 |  | PankajLawania10635113.xml
 |  | 10 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-06 06:42:09 | [NAME] |  | PankajLawania10635113.xml
 |  | 9 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-05 04:00:43 | Praduman [NAME] |  | PankajLawania10635113.xml
 |  | 8 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-05 04:00:42 | Praduman [NAME] |  | PankajLawania10635113.xml
 |  | 7 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-05 03:57:09 | Praduman [NAME] |  | PankajLawania10635113.xml
 |  | 6 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-04 11:39:35 | [NAME] |  | PankajLawania10635113.xml
 |  | 5 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-04 11:39:32 | [NAME] |  | PankajLawania10635113.xml
 |  | 4 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-04 11:39:14 | [NAME] |  | PankajLawania10635113.xml
 |  | 3 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-04 11:04:03 | [NAME] |  | PankajLawania10635113.xml
 |  | 2 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-04 11:03:05 | [NAME] |  | PankajLawania10635113.xml
 |  | 1 |  | PankajLawania10635113.xml | 2014-11-04 10:16:17 | 2014-11-04 10:16:17 | [NAME] 2 |  | PankajLawania10635113.xml
 | 14 | 10 |  | KikkeriRahul10984014.xml | 2014-11-04 10:49:58 | 2014-12-18 05:21:52 | Gunasekaran A Angamuthu |  | KikkeriRahul10984014.xml
 |  | 9 |  | KikkeriRahul10984014.xml | 2014-11-04 10:49:58 | 2014-11-10 05:39:12 | Nidhi Sharma 5 |  | KikkeriRahul10984014.xml
 |  | 8 |  | KikkeriRahul10984014.xml | 2014-11-04 10:49:58 | 2014-11-06 06:31:00 | [NAME] |  | KikkeriRahul10984014.xml
 |  | 7 |  | KikkeriRahul10984014.xml | 2014-11-04 10:49:58 | 2014-11-05 10:42:52 | [NAME] |  | KikkeriRahul10984014.xml
 |  | 6 |  | KikkeriRahul10984014.xml | 2014-11-04 10:49:58 | 2014-11-05 10:42:49 | [NAME] |  | KikkeriRahul10984014.xml
 |  | 5 |  | KikkeriRahul10984014.xml | 2014-11-04 10:49:58 | 2014-11-05 10:42:44 | [NAME] |  | KikkeriRahul10984014.xml
 |  | 4 |  | KikkeriRahul10984014.xml | 2014-11-04 10:49:58 | 2014-11-05 08:29:07 | [NAME] |  | KikkeriRahul10984014.xml
 |  | 3 |  | KikkeriRahul10984014.xml | 2014-11-04 10:49:58 | 2014-11-04 11:27:38 | [NAME] |  | KikkeriRahul10984014.xml
 |  | 2 |  | KikkeriRahul10984014.xml | 2014-11-04 10:49:58 | 2014-11-04 11:27:03 | [NAME] |  | KikkeriRahul10984014.xml
 |  | 1 |  | KikkeriRahul10984014.xml | 2014-11-04 10:49:58 | 2014-11-04 10:49:58 | [NAME] 2 |  | KikkeriRahul10984014.xml