KyleOliver
New Member
- Joined
- Apr 16, 2016
- Messages
- 31
Re: How to calulate hours worked on Sundays in a specific month
Hi,
I would like to know how to add all hours worked on the sundays in a month.
An employee might not work every Sunday in a month. Some employees will work one Sunday, others might work 2 or more and some might not work any Sundays in a month.
My table looks as follows;
<strike></strike><strike></strike>
<tbody>
</tbody><strike></strike>
How do I calculate just the hours worked on a Sunday?
Do I use a SUMIF / SUMIFS / SUMPRODUCT / MATCH / INDEX?
I have no idea, please someone help?
Regards,
Kyle
Hi,
I would like to know how to add all hours worked on the sundays in a month.
An employee might not work every Sunday in a month. Some employees will work one Sunday, others might work 2 or more and some might not work any Sundays in a month.
My table looks as follows;
<strike></strike><strike></strike>
A | B | C | D | E | F | G | H |
1 | Week Day<strike></strike> | <strike></strike>Punch Date<strike></strike> | <strike></strike>Time In<strike></strike> | <strike></strike>Lunch Start<strike></strike> | <strike></strike>Lunch End<strike></strike> | <strike></strike>Time Out<strike></strike> | <strike></strike>Hours Worked<strike></strike> |
2 | Monday | 01 Aug 2018 | 08:00 | 12:00 | 13:00 | 16:00 | 7:00 |
3 | Tuesday | 02 Aug 2018 | 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
4 | Wednesday | 03 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
5 | Thursday | 04 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
6 | Friday | 05 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
7 | Saturday | 06 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
8 | Sunday | 07 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
9 | Monday | 08 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
10 | Tuesday | 09 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
11 | Wednesday | 10 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
12 | Thursday | 11 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
13 | Friday | 12 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
14 | Saturday | 13 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
15 | Sunday | 14 Aug 2018 <strike></strike> | <strike></strike> | ||||
16 | Monday | 15 Aug 2018 <strike></strike> | <strike></strike> 08:00 <strike></strike> | <strike></strike> 12:00 <strike></strike> | <strike></strike> 13:00 <strike></strike> | <strike></strike> 16:00 <strike></strike> | <strike></strike> 7:00 <strike></strike> |
<tbody>
</tbody>
How do I calculate just the hours worked on a Sunday?
Do I use a SUMIF / SUMIFS / SUMPRODUCT / MATCH / INDEX?
I have no idea, please someone help?
Regards,
Kyle