LinkBack URL
About LinkBacks
Hi Jwildcat,
See if
=COUNTIFS(A1:A7,"<"&E1,C1:C7,">"&E1)
doesn't do what you are asking for.
Hi Jwildcat,
See if
=COUNTIFS(A1:A7,"<"&E1,C1:C7,">"&E1)
doesn't do what you are asking for.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Looks like that works great!
Is there anyway to account people who work through midnight?
example:
6:45 PM - 3:00 AM
6:45 PM - 3:00 AM
4:45 PM - 3:00 AM
9:45 PM - 6:00 AM
4:45 PM - 10:00 PM
People that are schedule at 1am?
I think you'd need to put a Date and Time in all you cells to deal with the "through midnight" question.
The formula should work if you added dates and times to all cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks