I would like to calculate the total hours for M, T, W, Th, F, Sa, Su
Can you please help with the formula? I was able to get the total hours for each employee but haven't been able to figure out how to break it down per day.
I have the following table:
<tbody>
</tbody>
And the following data on sheet1:
<tbody>
</tbody>
Can you please help with the formula? I was able to get the total hours for each employee but haven't been able to figure out how to break it down per day.
I have the following table:
Employee Name | Employee Number | 8/13/2018 | 8/14/2018 | 8/15/2018 | 8/16/2018 | 8/17/2018 | 8/18/2018 | 8/19/2018 | Total Hours |
M | T | W | Th | F | Sa | Su | |||
Name1 | 35EB600006 | ||||||||
Name2 | 35EB600092 |
<tbody>
</tbody>
And the following data on sheet1:
Employee Name | Employee # | Date | InTime | OutTime | Hours |
Name1 | 35EB600006 | 8/13/2018 | 8:00 AM | 12:00 PM | 4 |
Name1 | 35EB600006 | 8/13/2018 | 12:30 PM | 4:03 PM | 3.55 |
Name1 | 35EB600006 | 8/14/2018 | 6:30 AM | 4:08 PM | 9.633 |
Name1 | 35EB600006 | 8/15/2018 | 11:40 AM | 4:56 PM | 5.267 |
Name1 | 35EB600006 | 8/16/2018 | 8:00 AM | 4:00 PM | 8 |
Name1 | 35EB600006 | 8/17/2018 | 7:35 AM | 4:00 PM | 8.417 |
Name1 | 35EB600006 | 8/18/2018 | 11:50 AM | 2:10 PM | 2.333 |
Name2 | 35EB600092 | 8/13/2018 | 8:01 AM | 12:01 PM | 4 |
Name2 | 35EB600092 | 8/13/2018 | 12:33 PM | 4:05 PM | 3.533 |
Name2 | 35EB600092 | 8/14/2018 | 7:55 AM | 12:01 PM | 4.1 |
Name2 | 35EB600092 | 8/14/2018 | 12:36 PM | 4:14 PM | 3.633 |
Name2 | 35EB600092 | 8/15/2018 | 8:04 AM | 12:00 PM | 3.933 |
Name2 | 35EB600092 | 8/15/2018 | 12:37 PM | 4:01 PM | 3.4 |
Name2 | 35EB600092 | 8/16/2018 | 8:00 AM | 4:00 PM | 8 |
Name2 | 35EB600092 | 8/17/2018 | 8:30 AM | 4:00 PM | 7.5 |
<tbody>
</tbody>