I work for a company that wants me to keep my hours EXACTLY at 40 per week, right down to the minute.
I am allowed to work a little less or more each day but when Friday comes I have to adjust everything to meet that 40 hour/0 minute expectation for the week.
So I am thinking there must be a way of calculating this using Excel.
I work Mon--Fri during the day
There are always 4 punches per day -- In, Out-Lunch, In-Lunch, Out
What I would like to do is put into Excel my punch times (hh:mm) while seeing a sum of how many hours/minutes I have worked for the week.
Then when Friday comes along, and I have 3 of 4 Friday punches in, tweak my hours to exactly 40 by punching out Friday to the minute.
What I am hoping for is Excel to be able to tell me to the minute what time to punch out for the day on Friday so that the week equals 40 hours / 0 minutes.
Can someone please help me with how to accomplish this
I am allowed to work a little less or more each day but when Friday comes I have to adjust everything to meet that 40 hour/0 minute expectation for the week.
So I am thinking there must be a way of calculating this using Excel.
I work Mon--Fri during the day
There are always 4 punches per day -- In, Out-Lunch, In-Lunch, Out
What I would like to do is put into Excel my punch times (hh:mm) while seeing a sum of how many hours/minutes I have worked for the week.
Then when Friday comes along, and I have 3 of 4 Friday punches in, tweak my hours to exactly 40 by punching out Friday to the minute.
What I am hoping for is Excel to be able to tell me to the minute what time to punch out for the day on Friday so that the week equals 40 hours / 0 minutes.
Can someone please help me with how to accomplish this