Hello Everyone,
I am trying to create my own time sheet for work. I have attached what I have so far, column E deducts 0.5 hour break if I work over 6 hours. What I would like i5 to calculate is the amount of break time I get deducted in the week.
Work week: Friday to Thursday
Thanks in advance for your help
Hi and welcome.
I presume you mean you want I11 to calculate the break hours rather than I5 which already has a formula for 'regular hours'?
If so, try this in I11 and copied down to I25.
Formula:
Please Login or Register to view this content.
BSB
Thanks for the reply. but maybe I didn't explain what I'm looking for as a result in I11. I've attached another sheet with some times in it.
What I'm trying to get is when I enter the times column E deducts .5 if the time is over 6. what I want, because of those three times there are 2 that have .5 deducted I want I11 to result with 1.0.
Hopefully this explains better
Ken
Last edited by De3rcr; 01-20-2019 at 05:14 PM.
Why not add a column that contains the unadjusted time (could be hidden), then it’s just a case of working out the difference between the unadjusted and the adjusted totals.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I was hoping to have one cell with a formula to calculate everything. But if it is not possible I'll add more columns.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks