I have a question about Google sheets.
I am doing a labor calculation spreadsheet, and i need a formula to do the following :
A single brew on a single day takes 10 hours of labor. A subsequent brew on that day only takes an additional 4 hours. On a new day, the hours are the same.
So in a given week, we may have 3 total brew days where 5 brews are performed. The number of hours would be 38. What formula would i use to calculate this? It can either be a single cell for the input, where the input is total number of brews, or two cells for the input, where one cell is number of brews and one cell is number of days they were done over. But maximum number of brews in a day currently is 2.
Thanks for anyone helping in advance.