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
