Spreadsheet: 731917d1620673437-need-help-with-sumif-sumif-ot
Sheet: COVID All

OT
 |  |  |  |  |  | TOTAL
Employee Name | TL Unit | Time | Date | Start | End |  | Hours |  |  |  | Employee Name | TL Unit | [NAME] Cost | Total Hours | MANUAL TOTAL HOURS
emp 1 | 204 | 4:00 | 05/06/2021 | 4:00pm | 8:00pm |  | 4 |  |  |  | Emp 1 | 580-__-204 | 34.61 |  | 4
emp 2 | 215 | 8:00 | 03/27/2021 | 6:30am | 3:00pm |  | 8 |  |  |  | Emp 2 | 580-__-215 | 67.45 |  | 8
emp 3 | 217 | 2:00 | 09/28/2020 | 5:00am | 7:00am |  | 2 |  |  |  | Emp 3 | 580-__-217 | 73.71 |  | 48
emp 3 | 217 | 2:00 | 09/29/2020 | 5:00am | 7:00am |  | 2 |  |  |  | Emp 4 | 580-__-217 | 68.1 |  | 7.5
emp 3 | 217 | 1:30 | 09/30/2020 | 5:00am | 6:30am |  | 1.5 |  |  |  | Emp 5 | 580-__-217 | 40.73 |  | 13.75
emp 3 | 217 | 1:30 | 10/01/2020 | 5:00am | 6:30am |  | 1.5 |  |  |  | Emp 6 | 580-__-222 | 51.06 |  | 8.5
emp 3 | 217 | 1:30 | 10/02/2020 | 5:00am | 6:30am |  | 1.5 |  |  |  | Emp 7 | 580-__-227 | 83.09 |  | 1.75
emp 3 | 217 | 1:30 | 10/05/2020 | 5:00am | 6:30am |  | 1.5 |  |  |  | Emp 8 | 580-__-227 | 83.07 |  | 2
emp 3 | 217 | 1:30 | 10/06/2020 | 5:00am | 6:30am |  | 1.5 |  |  |  | Emp 9 | 580-__-230 | 54.95 |  | 4.5
emp 3 | 217 | 1:30 | 10/07/2020 | 5:00am | 6:30am |  | 1.5 |  |  |  | Emp 10 | 580-__-230 | 36.65 |  | 2
emp 3 | 217 | 1:30 | 10/08/2020 | 5:00am | 6:30am |  | 1.5
emp 3 | 217 | 1:30 | 10/09/2020 | 5:00am | 6:30am |  | 1.5
emp 3 | 217 | 1:30 | 10/14/2020 | 5:00am | 6:30am |  | 1.5
emp 3 | 217 | 1:30 | 10/15/2020 | 5:00am | 6:30am |  | 1.5
emp 3 | 217 | 1:00 | 01/19/2021 | 4:30am | 5:30am |  | 1
emp 3 | 217 | 1:00 | 01/20/2021 | 5:30am | 6:30am |  | 1
emp 3 | 217 | 1:00 | 01/21/2021 | 5:30am | 6:30am |  | 1
emp 3 | 217 | 1:30 | 02/12/2021 | 5:00am | 6:30am |  | 1.5
emp 3 | 217 | 1:30 | 03/01/2021 | 5:00am | 6:30am |  | 1.5 |  |  |  | Title | Simple SumIF
emp 3 | 217 | 1:30 | 03/02/2021 | 5:00am | 6:30am |  | 1.5 |  |  | Emp 1 | =SUMIF($A$4:$H$49,L4,H:H)
emp 3 | 217 | 1:30 | 03/03/2021 | 5:00am | 6:30am |  | 1.5
emp 3 | 217 | 1:30 | 03/04/2021 | 5:00am | 6:30am |  | 1.5 |  |  | I'm not sure why this isn't working?  I converted Time (col. C) to number (col. H) manually, is there a way to convert this time to a number?
emp 3 | 217 | 1:30 | 03/05/2021 | 5:00am | 6:30am |  | 1.5 |  |  | I need most help with figuring out why this formula isn't working?  (Col. O, row 4) - I used =SUMIF($A$4:$H$49,L4,H:H)
emp 3 | 217 | 8:00 | 04/17/2021 | 6:30am | 3:00pm |  | 8
emp 3 | 217 | 9:00 | 03/27/2021 | 6:30am | 4:00pm |  | 9
emp 4 | 217 | 1:30 | 09/30/2020 | 5:00am | 6:30am |  | 1.5
emp 4 | 217 | 1:30 | 01/04/2021 | 5:00am | 6:30am |  | 1.5
emp 4 | 217 | 1:30 | 02/01/2021 | 5:30am | 7:00am |  | 1.5
emp 4 | 217 | 1:30 | 02/02/2021 | 5:30am | 7:00am |  | 1.5
emp 4 | 217 | 1:30 | 02/03/2021 | 5:30am | 7:00am |  | 1.5
emp 5 | 217 | 2:45 | 10/21/2020 | 4:00pm | 6:45pm |  | 2.75
emp 5 | 217 | 3:00 | 10/22/2020 | 4:00pm | 7:00pm |  | 3
emp 5 | 217 | 8:00 | 10/24/2020 | 7:30am | 4:00pm |  | 8
emp 6 | 222 | 1:30 | 12/18/2020 | 6:00am | 7:30am |  | 1.5
emp 6 | 222 | 1:30 | 12/18/2020 | 6:00am | 7:30am |  | 1.5
emp 6 | 222 | 1:30 | 02/12/2021 | 4:00pm | 5:30pm |  | 1.5
emp 6 | 222 | 1:30 | 02/12/2021 | 4:00pm | 5:30pm |  | 1.5
emp 6 | 222 | 2:30 | 12/16/2020 | 4:00pm | 6:30pm |  | 2.5
emp 7 | 227 | 1:45 | 02/09/2021 | 4:30pm | 6:15pm |  | 1.75
emp 8 | 227 | 1:00 | 11/25/2020 | 4:00pm | 5:00pm |  | 1
emp 8 | 227 | 1:00 | 01/26/2021 | 4:00pm | 5:00pm |  | 1
emp 9 | 230 | 4:30 | 10/25/2020 | 12:00pm | 4:30pm |  | 4.5
emp 10 | 230 | 0:30 | 12/29/2020 | 4:00pm | 4:30pm |  | 0.5
emp 10 | 230 | 0:30 | 12/30/2020 | 4:00pm | 4:30pm |  | 0.5
emp 10 | 230 | 0:30 | 12/31/2020 | 4:00pm | 4:30pm |  | 0.5
emp 10 | 230 | 0:30 | 02/11/2021 | 4:00pm | 4:30pm |  | 0.5