Spreadsheet: 823000d1679640322-if-and-condition-to-calculate-time-excel-forum
Sheet: Sheet1

Received_Date | Closed_Date | Received time
2023-01-28 00:16:00 | 2023-01-30 15:05:00 | 12:16:00 AM
2023-01-28 01:18:00 | 2023-01-30 15:12:00 | 01:18:00 AM
2023-01-28 05:37:00 | 2023-01-30 15:29:00 | 05:37:00 AM
2023-01-28 02:39:00 | 2023-01-30 15:54:00 | 02:39:00 AM
2023-01-28 04:02:00 | 2023-01-30 16:02:00 | 04:02:00 AM
2023-01-28 00:11:00 | 2023-01-30 16:26:00 | 12:11:00 AM
2023-01-30 13:44:00 | 2023-01-30 17:21:00 | 01:44:00 PM
2023-01-30 15:09:00 | 2023-01-30 18:12:00 | 03:09:00 PM
2023-01-30 18:25:00 | 2023-01-30 18:41:00 | 06:25:00 PM
2023-01-30 18:52:00 | 2023-01-30 18:58:00 | 06:52:00 PM
2023-01-30 18:53:00 | 2023-01-30 19:06:00 | 06:53:00 PM
2023-01-30 18:58:00 | 2023-01-30 19:21:00 | 06:58:00 PM
2023-01-30 19:55:00 | 2023-01-30 20:27:00 | 07:55:00 PM
2023-01-30 20:00:00 | 2023-01-30 20:47:00 | 08:00:00 PM
2023-01-30 20:18:00 | 2023-01-30 21:33:00 | 08:18:00 PM
2023-01-30 20:24:00 | 2023-01-30 21:19:00 | 08:24:00 PM
2023-01-30 20:58:00 | 2023-01-30 21:51:00 | 08:58:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 16:50:00 | 2023-01-30 17:21:00 | 04:50:00 PM
2023-01-30 21:00:00 | 2023-01-30 21:29:00 | 09:00:00 PM
2023-01-30 21:13:00 | 2023-01-30 21:39:00 | 09:13:00 PM
2023-01-30 21:25:00 | 2023-01-30 21:44:00 | 09:25:00 PM
2023-01-30 21:37:00 | 2023-01-30 21:53:00 | 09:37:00 PM
2023-01-30 21:43:00 | 2023-01-30 21:58:00 | 09:43:00 PM
2023-01-30 21:44:00 | 2023-01-30 22:06:00 | 09:44:00 PM
2023-01-30 21:55:00 | 2023-01-30 22:14:00 | 09:55:00 PM
2023-01-30 22:07:00 | 2023-01-30 22:19:00 | 10:07:00 PM
2023-01-30 22:13:00 | 2023-01-30 22:22:00 | 10:13:00 PM
2023-01-30 22:15:00 | 2023-01-30 22:27:00 | 10:15:00 PM
2023-01-30 22:24:00 | 2023-01-30 22:38:00 | 10:24:00 PM
2023-01-30 22:37:00 | 2023-01-30 22:57:00 | 10:37:00 PM
2023-01-30 22:41:00 | 2023-01-30 22:59:00 | 10:41:00 PM
2023-01-31 11:14:00 | 2023-01-31 12:07:00 | 11:14:00 AM
2023-01-31 11:14:00 | 2023-01-31 12:07:00 | 11:14:00 AM
2023-01-31 11:14:00 | 2023-01-31 12:07:00 | 11:14:00 AM
2023-01-31 11:14:00 | 2023-01-31 12:07:00 | 11:14:00 AM
2023-01-31 11:14:00 | 2023-01-31 12:07:00 | 11:14:00 AM
2023-01-31 11:14:00 | 2023-01-31 12:07:00 | 11:14:00 AM
2023-01-31 11:14:00 | 2023-01-31 12:07:00 | 11:14:00 AM
2023-01-31 11:14:00 | 2023-01-31 12:07:00 | 11:14:00 AM
2023-01-31 11:14:00 | 2023-01-31 12:07:00 | 11:14:00 AM
2023-01-31 11:14:00 | 2023-01-31 12:07:00 | 11:14:00 AM
2023-02-21 20:48:00 | 2023-02-22 16:18:00 | 08:48:00 PM
2023-02-21 20:51:00 | 2023-02-22 16:30:00 | 08:51:00 PM
2023-02-21 20:54:00 | 2023-02-22 17:10:00 | 08:54:00 PM
2023-02-21 21:11:00 | 2023-02-22 17:22:00 | 09:11:00 PM
2023-02-21 21:47:00 | 2023-02-22 17:29:00 | 09:47:00 PM
2023-02-21 23:04:00 | 2023-02-22 18:08:00 | 11:04:00 PM