Spreadsheet: 813944d1674066978-log-in-and-log-out-with-time-calculations-sample-workbook
Sheet: Sheet1

DECEMBER
Date: | 2022-12-01 00:00:00
Agent: | REP NAME |  |  |  | 265 MINS
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 7:55AM | 8:56AM | 2022-12-01 00:00:00 | Break
REP NAME | [NAME] | 9:20AM | 2022-12-01 00:00:00 | Break | 5 MINS
REP NAME | 9:35AM | 10:53AM | 2022-12-01 00:00:00 | Default
 |  | Still not fixed.
12.2.2022 | Called Out
Date: | 2022-12-05 00:00:00
Agent: | REP NAME |  |  |  | 25
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 7:58AM | 8:06AM | 2022-12-05 00:00:00 | Default
REP NAME | 8:06AM | 8:07AM | 2022-12-05 00:00:00 | Default
REP NAME | 8:07AM | 8:51AM | 2022-12-05 00:00:00 | Break | 6 |  | 7 MINS
REP NAME | [NAME] | 9:25AM | 2022-12-05 00:00:00 | Break | 12
REP NAME | 9:42AM | 10:37AM | 2022-12-05 00:00:00 | Break | 7
REP NAME | 10:44AM | 11:20AM | 2022-12-05 00:00:00 | Lunch
REP NAME | 11:50AM | 11:51AM | 2022-12-05 00:00:00 | End of Shift
[NAME] | Called Out
Date: | 2022-12-07 00:00:00
Agent: | REP NAME |  |  |  | 41
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 7:54AM | 9:17AM | 2022-12-07 00:00:00 | Break | 8
REP NAME | 9:38AM | 9:56AM | 2022-12-07 00:00:00 | Break | 4
REP NAME | 10:00AM | 10:43AM | 2022-12-07 00:00:00 | Default | 5
REP NAME | 10:48AM | 11:08AM | 2022-12-07 00:00:00 | Lunch | 5
REP NAME | 11:40AM | 1:35PM | 2022-12-07 00:00:00 | Break | 4
REP NAME | 1:39PM | 2:37PM | 2022-12-07 00:00:00 | Break | 10
REP NAME | 2:55PM | 3:36PM | 2022-12-07 00:00:00 | Break | 5
REP NAME | 3:41PM | 4:25PM | 2022-12-07 00:00:00 | End of Shift
Date: | 2022-12-08 00:00:00
Agent: | REP NAME
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 7:54AM | 9:16AM | 2022-12-08 00:00:00 | Break
REP NAME | 9:31AM | 10:58AM | 2022-12-08 00:00:00 | Break
REP NAME | 11:02AM | 11:05AM | 2022-12-08 00:00:00 | Lunch
REP NAME | 11:39AM | 1:50PM | 2022-12-08 00:00:00 | Break
REP NAME | 1:54PM | 2:31PM | 2022-12-08 00:00:00 | Lunch
REP NAME | 2:46PM | 4:28PM | 2022-12-08 00:00:00 | End of Shift
Date: | 2022-12-09 00:00:00
Agent: | REP NAME |  |  |  | 38
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 7:57AM | 9:26AM | 2022-12-09 00:00:00 | Lunch
REP NAME | 9:26AM | 9:32AM | 2022-12-09 00:00:00 | Break | 12
REP NAME | [NAME] | 10:20AM | 2022-12-09 00:00:00 | Break | 3
REP NAME | 10:23AM | 11:09AM | 2022-12-09 00:00:00 | Lunch | 7
REP NAME | 11:42AM | 1:00PM | 2022-12-09 00:00:00 | Call Referrals | 2
REP NAME | 1:32PM | 2:36PM | 2022-12-09 00:00:00 | Break | 10
REP NAME | 2:55PM | 3:28PM | 2022-12-09 00:00:00 | Break | 4
REP NAME | 3:32PM | 4:27PM | 2022-12-09 00:00:00 | End of Shift
Date: | 2022-12-12 00:00:00
Agent: | REP NAME
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 7:59AM | 9:16AM | 2022-12-12 00:00:00 | Break
REP NAME | 9:29AM | 10:18AM | 2022-12-12 00:00:00 | Break | 5
REP NAME | 10:23AM | 11:06AM | 2022-12-12 00:00:00 | Lunch
REP NAME | 11:37AM | 1:07PM | 2022-12-12 00:00:00 | Break | 4
REP NAME | 1:11PM | 2:30PM | 2022-12-12 00:00:00 | Break
REP NAME | 2:47PM | 4:25PM | 2022-12-12 00:00:00 | End of Shift
Date: | 2022-12-13 00:00:00
Agent: | REP NAME
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 7:58AM | 9:20AM | 2022-12-13 00:00:00 | Break
REP NAME | 9:36AM | 11:15AM | 2022-12-13 00:00:00 | Lunch
REP NAME | 11:44AM | 12:29PM | 2022-12-13 00:00:00 | Break | 3
REP NAME | 12:32PM | 2:31PM | 2022-12-13 00:00:00 | Break
REP NAME | 2:48PM | 4:41PM | 2022-12-13 00:00:00 | End of Shift
Date: | 2022-12-14 00:00:00
Agent: | REP NAME
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 7:55AM | [NAME] | 2022-12-14 00:00:00 | Break
REP NAME | 9:31AM | 11:03AM | 2022-12-14 00:00:00 | Lunch
REP NAME | 11:37AM | 1:15PM | 2022-12-14 00:00:00 | Default
REP NAME | 1:18PM | 1:18PM | 2022-12-14 00:00:00 | Call Referrals
REP NAME | 1:33PM | 2:36PM | 2022-12-14 00:00:00 | Break
REP NAME | 2:54PM | 4:25PM | 2022-12-14 00:00:00 | End of Shift
Date: | 2022-12-15 00:00:00
Agent: | REP NAME
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 7:57AM | 9:15AM | 2022-12-15 00:00:00 | Break
REP NAME | 9:31AM | 10:03AM | 2022-12-15 00:00:00 | Break | 4
REP NAME | 10:07AM | 11:09AM | 2022-12-15 00:00:00 | Lunch
REP NAME | 11:43AM | 2:38PM | 2022-12-15 00:00:00 | Break
REP NAME | 2:55PM | 4:29PM | 2022-12-15 00:00:00 | End of Shift
Date: | 2022-12-16 00:00:00
Agent: | REP NAME
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 7:56AM | 9:21AM | 2022-12-16 00:00:00 | Break
REP NAME | 9:37AM | 10:48AM | 2022-12-16 00:00:00 | Break | 2
REP NAME | 10:50AM | 11:07AM | 2022-12-16 00:00:00 | Lunch
REP NAME | 11:43AM | 2:28PM | 2022-12-16 00:00:00 | Break
REP NAME | 2:46PM | 4:25PM | 2022-12-16 00:00:00 | End of Shift
Date: | 2022-12-19 00:00:00
Agent: | REP NAME
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 7:55AM | 8:10AM | 2022-12-19 00:00:00 | Default
REP NAME | 8:10AM | [NAME] | 2022-12-19 00:00:00 | Lunch
REP NAME | [NAME] | 9:15AM | 2022-12-19 00:00:00 | Break
REP NAME | 9:31AM | 11:09AM | 2022-12-19 00:00:00 | Lunch
REP NAME | 11:41AM | 12:05PM | 2022-12-19 00:00:00 | Break | 5
REP NAME | 12:10PM | 1:50PM | 2022-12-19 00:00:00 | Break | 1
REP NAME | 1:51PM | 2:33PM | 2022-12-19 00:00:00 | Break
REP NAME | 2:47PM | 3:27PM | 2022-12-19 00:00:00 | Break | 4
REP NAME | 3:31PM | 4:29PM | 2022-12-19 00:00:00 | End of Shift
12.20-29.22 | PTO
Date: | 2022-12-30 00:00:00
Agent: | REP NAME
Agent Name | [NAME] | Logout Time | Logout Date | [NAME]
REP NAME | 8:38AM | 9:39AM | 2022-12-30 00:00:00 | Break
REP NAME | [NAME] | 10:45AM | 2022-12-30 00:00:00 | Break | 1
REP NAME | 10:46AM | 10:57AM | 2022-12-30 00:00:00 | Break | 3
REP NAME | 11:00AM | 11:11AM | 2022-12-30 00:00:00 | Lunch
REP NAME | 11:42AM | 1:15PM | 2022-12-30 00:00:00 | Call Referrals
REP NAME | 1:30PM | 1:44PM | 2022-12-30 00:00:00 | Break | 1
REP NAME | 1:45PM | 2:29PM | 2022-12-30 00:00:00 | Break
REP NAME | 2:46PM | 2:58PM | 2022-12-30 00:00:00 | Break | 2
REP NAME | 3:00PM | 4:06PM | 2022-12-30 00:00:00 | Break | 2
REP NAME | 4:08PM | 4:25PM | 2022-12-30 00:00:00 | End of Shift