M
Michelle
I'm designing a time tracking spreadsheet. However, some
employees work 5 8-hour days, and others work 4 10-hour
days. What I need to determine is how many Mondays or
Fridays there are in a given time period in order to
eliminate those from the final "you should have worked a
total of x hours this week" calculation, which is working
fine for the 5 8-hour folks.
The kicker here is that the time period may have 15 or 16
days in it based on how the payroll period ends.
How can I find out how many Mondays or Fridays are in a
given time range?
Any help much appreciated!
Michelle
employees work 5 8-hour days, and others work 4 10-hour
days. What I need to determine is how many Mondays or
Fridays there are in a given time period in order to
eliminate those from the final "you should have worked a
total of x hours this week" calculation, which is working
fine for the 5 8-hour folks.
The kicker here is that the time period may have 15 or 16
days in it based on how the payroll period ends.
How can I find out how many Mondays or Fridays are in a
given time range?
Any help much appreciated!
Michelle