I have a sheet that has a few thousand rows of data. I am trying to find the percentage of occurrences by shift are logged between 04:30 and 06:10 or between 17:30 and 18:10.
I figured out how to count the occurrences between the 4 shifts in column B and show it in column D. My problem counting column A for the above time restrictions is the date being in the same cell. Any way to count these so I can find the percentage?
shifts.PNG
I'd use a helper column with an IF() test to determine whether the shifts are between the times you specify and if so return the value of column B
Formula:
Please Login or Register to view this content.
Then just sum the helper column and express it as a % of column B
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks