Forum Discussion
Add two formulas to one cell?
If you have a similar problem, please provide detailed information about your setup, and if possible, attach a small sample workbook without sensitive information. Alternatively, upload it to for example Google Drive, OneDrive or Dropbox and post a link to the uploaded file in a reply.
Here goes.... I have no idea what I am doing but somehow continue to figure it out lol!! Here and YouTube are invaluable!!
Here is what I need -
In cell Z8 is the total hours worked. In Z9 I would like it to reflect total break time. Every 5 hours I deduct 0.5.
0-4 hrs worked - 0
5-9hrs - 0.5hrs
10-14hrs - 1hr
15-19hrs worked - 1.5hrs
20-24hrs worked - 2hrs
25-29hrs worked - 2.5hrs
30-34hrs worked - 3hrs
Does that make sense? Basically I need to show the total scheduled AND total break times - then cell AA8 would be =Z8-Z9.
https://docs.google.com/spreadsheets/d/1vjpFhJ3e4NonjMReD4CCAowMmu3RioXP/edit?usp=share_link&ouid=100123223718955834672&rtpof=true&sd=true
HansVogelaar
AMAZING....but.... I just realized -
I need to take .5 off for every 5 hours works but NOT on the total at end of week. Reason is - if someone works a 3 hours shift one day, and a 7 hour shift one day it takes off 1 whole hour when in reality they did not take a break on the 3hr shift and only 30 mins on the 7 hour shift. The formula reads the total as 10 hours so deducts two breaks....
SO SORRY if I just made this more complicated!!!
MANY MANY THANKS!!!!In which cells do you record the hours worked per day?