Hey, everyone!
I'm wanting to sum how much "partial time" an employee worked during the week. What I mean by "partial time" is the time they didn't work during their 8 hour shift.
MON TUES WED THU FRI TOTAL HRS WORKED PARTIAL TIME 4 8 5 8 off 25 7
The expected result is 7 because 8-4=4 and 8-5=3.
Unfortunately, I haven't been able to find a formula where I get that result. Perhaps I'm looking at things the wrong way or I have an incorrect setup. Any help is appreciated.
Thank you all!
How about this?
=40-(COUNTIFS(A2:E2,"off")*8)-SUM(A2:E2)
where A2:E2 are the cells containing the week's data.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
With a bit of an adjustment, this works perfectly. Thank you!
Last edited by AliGW; 07-15-2019 at 11:11 AM. Reason: Please don't quote unnecessarily!
Good to know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks