Spreadsheet: 881246d1729237144-req-formula-to-consolidate-time-worked-consolidate_time_worked
Sheet: Page 1

Opened Date | Updated Date | Ticket Number | Assigned to | Time worked in Seconds
2024-10-17 00:00:00 | 2024-10-17 06:00:05 | 19202641 | Jitu | 70
2024-10-17 00:00:00 | 2024-10-17 09:39:54 | 19202641 | Jitu | 338
2024-10-10 00:00:00 | 2024-10-10 14:56:25 | 3183722 | Teju | 285
2024-10-10 00:00:00 | 2024-10-10 14:58:32 | 3183722 | Teju | 75
2024-10-10 00:00:00 | 2024-10-10 14:51:55 | 3183722 | Teju | 14
2024-10-07 00:00:00 | 2024-10-07 05:51:01 | 19164727 | Jitu | 33
2024-10-07 00:00:00 | 2024-10-07 06:07:43 | 19164727 | Jitu | 987
2024-10-07 00:00:00 | 2024-10-07 06:11:42 | 19164727 | Jitu | 8
2024-10-07 00:00:00 | 2024-10-07 05:50:02 | 19164727 | Jitu | 10
2024-10-07 00:00:00 | 2024-10-07 06:55:43 | 19164727 | Jitu | 2632
2024-10-03 00:00:00 | 2024-10-03 16:02:12 | 3170449 | Jitu | 115
2024-10-03 00:00:00 | 2024-10-03 15:42:08 | 3170449 | Jitu | 258
2024-10-03 00:00:00 | 2024-10-03 05:23:56 | 3170449 | Jitu | 9
2024-10-03 00:00:00 | 2024-10-03 15:59:29 | 3170449 | Jitu | 14
2024-10-02 00:00:00 | 2024-10-02 07:28:17 | 19150637 | Jitesh | 2
2024-10-02 00:00:00 | 2024-10-02 07:28:05 | 19150637 | Jitesh | 38
2024-10-02 00:00:00 | 2024-10-02 11:58:50 | 19150637 | Jitesh | 4135
2024-10-02 00:00:00 | 2024-10-02 08:31:42 | 19150637 | Jitesh | 751
2024-10-02 00:00:00 | 2024-10-02 07:53:55 | 19150637 | Jitesh | 1534
2024-10-02 00:00:00 | 2024-10-02 07:54:17 | 19150637 | Jitesh | 8
2024-10-02 00:00:00 | 2024-10-02 08:02:23 | 19150637 | Jitesh | 56
2024-10-02 00:00:00 | 2024-10-02 10:29:49 | 19150637 | Jitesh | 456
2024-10-02 00:00:00 | 2024-10-02 10:49:49 | 19150637 | Jitesh | 1118
2024-10-04 00:00:00 | 2024-10-17 09:46:18 | 3172544 | Jitesh | 27
2024-10-04 00:00:00 | 2024-10-04 05:17:47 | 3172544 | Jitesh | 6
2024-10-04 00:00:00 | 2024-10-08 14:53:36 | 3172544 | Jitesh | 24
2024-10-04 00:00:00 | 2024-10-14 09:44:50 | 3172544 | Jitesh | 156
2024-10-04 00:00:00 | 2024-10-08 07:07:44 | 3172544 | Jitesh | 8
2024-10-04 00:00:00 | 2024-10-14 09:37:21 | 3172544 | Jitesh | 579
2024-10-04 00:00:00 | 2024-10-08 09:11:23 | 3172544 | Jitesh | 82
2024-10-01 00:00:00 | 2024-10-03 15:35:15 | 3165736 | Jitesh | 98
2024-10-01 00:00:00 | 2024-10-03 15:03:20 | 3165736 | Jitesh | 11
2024-10-01 00:00:00 | 2024-10-01 12:46:52 | 3165736 | Jitesh | 199
2024-10-01 00:00:00 | 2024-10-04 13:54:55 | 3165736 | Jitesh | 80
2024-10-01 00:00:00 | 2024-10-01 12:51:53 | 3165736 | Jitesh | 296
2024-10-01 00:00:00 | 2024-10-01 07:36:02 | 3165736 | Jitesh | 42
2024-10-01 00:00:00 | 2024-10-01 08:51:18 | 3165736 | Jitesh | 93
2024-10-15 00:00:00 | 2024-10-17 13:40:52 | 3189809 | [NAME] | 430
2024-10-15 00:00:00 | 2024-10-15 05:27:56 | 3189809 | [NAME] | 10
2024-10-15 00:00:00 | 2024-10-17 13:36:32 | 3189809 | [NAME] | 233
2024-10-09 00:00:00 | 2024-10-09 05:02:18 | 3180045 | Jitesh | 15
2024-10-09 00:00:00 | 2024-10-09 14:18:20 | 3180045 | Jitesh | 22
2024-10-09 00:00:00 | 2024-10-09 07:35:33 | 3180045 | Jitesh | 330
2024-10-09 00:00:00 | 2024-10-09 07:30:00 | 3180045 | Jitesh | 4
2024-10-09 00:00:00 | 2024-10-09 08:47:10 | 3180044 | Jitu | 142
2024-10-09 00:00:00 | 2024-10-09 07:16:25 | 3180044 | Jitu | 5
2024-10-09 00:00:00 | 2024-10-09 05:00:44 | 3180044 | Jitu | 6
2024-10-09 00:00:00 | 2024-10-10 06:06:08 | 3180044 | Jitu | 79
2024-10-04 00:00:00 | 2024-10-07 15:54:09 | 3172542 | Teju | 94
2024-10-04 00:00:00 | 2024-10-07 18:22:49 | 3172542 | Teju | 48
2024-10-04 00:00:00 | 2024-10-07 16:47:39 | 3172542 | Teju | 282
2024-10-04 00:00:00 | 2024-10-04 05:15:36 | 3172542 | Teju | 10
2024-10-14 00:00:00 | 2024-10-16 15:44:18 | 3187376 | Jitu | 63
2024-10-14 00:00:00 | 2024-10-15 17:01:38 | 3187376 | Jitu | 1483
2024-10-14 00:00:00 | 2024-10-18 06:29:42 | 3187376 | Jitu | 98
2024-10-14 00:00:00 | 2024-10-14 11:25:23 | 3187376 | Jitu | 477
2024-10-14 00:00:00 | 2024-10-14 07:03:00 | 3187376 | Jitu | 15
2024-10-04 00:00:00 | 2024-10-08 07:01:06 | 3173386 | Jitu | 70
2024-10-04 00:00:00 | 2024-10-08 08:53:30 | 3173386 | Jitu | 74
2024-10-04 00:00:00 | 2024-10-04 12:33:29 | 3173386 | Jitu | 2125
2024-10-04 00:00:00 | 2024-10-04 11:57:58 | 3173386 | Jitu | 31
2024-10-04 00:00:00 | 2024-10-04 14:19:55 | 3173386 | Jitu | 633
2024-10-04 00:00:00 | 2024-10-07 09:36:33 | 3173386 | Jitu | 99
2024-10-04 00:00:00 | 2024-10-04 11:57:12 | 3173386 | Jitu | 19
2024-10-08 00:00:00 | 2024-10-08 07:56:12 | 3177457 | Jitesh | 29
2024-10-08 00:00:00 | 2024-10-08 06:32:14 | 3177457 | Jitesh | 6
2024-10-08 00:00:00 | 2024-10-08 07:08:38 | 3177457 | Jitesh | 3
2024-10-08 00:00:00 | 2024-10-08 07:55:14 | 3177457 | Jitesh | 123
2024-10-08 00:00:00 | 2024-10-14 07:02:49 | 3178232 | Jitu | 72
2024-10-08 00:00:00 | 2024-10-08 11:22:57 | 3178232 | Jitu | 792
2024-10-08 00:00:00 | 2024-10-11 07:11:45 | 3178232 | Jitu | 45
2024-10-08 00:00:00 | 2024-10-08 11:09:20 | 3178232 | Jitu | 8
2024-10-08 00:00:00 | 2024-10-08 14:23:22 | 3178232 | Jitu | 51
2024-10-03 00:00:00 | 2024-10-03 05:26:52 | 3170451 | Jitesh | 10
2024-10-03 00:00:00 | 2024-10-03 07:13:48 | 3170451 | Jitesh | 311
2024-10-03 00:00:00 | 2024-10-03 07:19:12 | 3170451 | Jitesh | 322
2024-10-03 00:00:00 | 2024-10-03 15:33:11 | 3170451 | Jitesh | 274
2024-10-04 00:00:00 | 2024-10-09 07:10:01 | 3172545 | Jitu | 21
2024-10-04 00:00:00 | 2024-10-08 10:49:14 | 3172545 | Jitu | 134
2024-10-04 00:00:00 | 2024-10-08 10:46:31 | 3172545 | Jitu | 38
2024-10-04 00:00:00 | 2024-10-08 10:54:18 | 3172545 | Jitu | 296
2024-10-04 00:00:00 | 2024-10-04 05:19:46 | 3172545 | Jitu | 14
2024-10-04 00:00:00 | 2024-10-04 11:22:23 | 19161719 | Jitu | 130
2024-10-04 00:00:00 | 2024-10-04 11:19:14 | 19161719 | Jitu | 7
2024-10-04 00:00:00 | 2024-10-04 11:23:54 | 19161719 | Jitu | 86
2024-10-04 00:00:00 | 2024-10-04 11:38:27 | 19161719 | Jitu | 115
2024-10-04 00:00:00 | 2024-10-04 11:20:08 | 19161719 | Jitu | 50
2024-10-04 00:00:00 | 2024-10-04 11:19:02 | 19161719 | Jitu | 235
2024-04-09 00:00:00 | 2024-10-04 05:24:22 | APPSINC1150379 | Teju | 14
2024-04-09 00:00:00 | 2024-10-07 13:31:16 | APPSINC1150379 | Teju | 183
2024-10-14 00:00:00 | 2024-10-14 11:10:47 | 3187613 | Jitesh | 768
2024-10-14 00:00:00 | 2024-10-15 07:34:20 | 3187613 | Jitesh | 695
2024-10-14 00:00:00 | 2024-10-14 09:00:02 | 3187613 | Jitesh | 15
2024-10-14 00:00:00 | 2024-10-16 15:44:28 | 3187613 | Jitesh | 82
2024-10-14 00:00:00 | 2024-10-14 09:26:57 | 3187613 | Jitesh | 8
2024-10-14 00:00:00 | 2024-10-17 07:18:53 | 3187613 | Jitesh | 25
2024-10-03 00:00:00 | 2024-10-04 11:50:58 | 19156404 | Jitesh | 193
2024-10-03 00:00:00 | 2024-10-04 07:32:22 | 19156404 | Jitesh | 268
2024-10-03 00:00:00 | 2024-10-03 09:05:42 | 19156404 | Jitesh | 26
2024-10-09 00:00:00 | 2024-10-09 13:53:09 | 19175419 | Jitu | 63
2024-10-09 00:00:00 | 2024-10-09 14:02:56 | 19175419 | Jitu | 511
2024-10-09 00:00:00 | 2024-10-09 14:15:56 | 19175419 | Jitu | 381
2024-10-09 00:00:00 | 2024-10-10 06:02:30 | 19175419 | Jitu | 3311
2024-10-18 00:00:00 | 2024-10-18 08:13:20 | 19207222 | Jitu | 1097
2024-10-18 00:00:00 | 2024-10-18 07:54:59 | 19207222 | Jitu | 134
2024-10-17 00:00:00 | 2024-10-18 06:29:55 | 3195751 | Jitu | 5
2024-10-17 00:00:00 | 2024-10-17 15:59:09 | 3195751 | Jitu | 18
2024-10-17 00:00:00 | 2024-10-17 13:54:27 | 3195282 | Teju | 11
2024-10-17 00:00:00 | 2024-10-17 19:12:34 | 3195282 | Teju | 28
2024-10-07 00:00:00 | 2024-10-11 07:12:47 | 3174806 | Jitu | 15
2024-10-07 00:00:00 | 2024-10-07 07:04:45 | 3174806 | Jitu | 8
2024-10-07 00:00:00 | 2024-10-07 07:17:04 | 3174806 | Jitu | 116
2024-10-07 00:00:00 | 2024-10-09 07:16:07 | 3174806 | Jitu | 11
2024-10-07 00:00:00 | 2024-10-11 07:12:29 | 3174806 | Jitu | 36
2024-10-14 00:00:00 | 2024-10-15 17:06:10 | 19192538 | [NAME] | 2982
2024-10-14 00:00:00 | 2024-10-17 08:00:05 | 19192538 | [NAME] | 826
2024-10-14 00:00:00 | 2024-10-14 17:18:52 | 19192538 | [NAME] | 85