Hi all,
I am a bit confused on this one.
I work shifts of 12.3 hours. I have a certain amount of hours to complete before I can go on holiday. I would like cell D2 to tell me on what day I finish my hours.
As you can see in cell C324, I have to work 2.7 hours and then my hours for the season will be finished.
I need the formula in D2 to say "Find the cell in column C that is less than 12.3 but more than zero (as the cells below C324 are blank) and display the information in the cell in column D next to that cell.
So D2 should display cell D324 or 06/06/2024.
Can anybody help?
EDIT:
My apologies, I have made an error in my calculations.
Cell D2 actually needs to show D325 as that is the first cell that has zero hours remaining and would be the day I have finished working. Cell D324 shows that I still have 2.7 hours to work the next day.
I am a bit confused on this one.
I work shifts of 12.3 hours. I have a certain amount of hours to complete before I can go on holiday. I would like cell D2 to tell me on what day I finish my hours.
As you can see in cell C324, I have to work 2.7 hours and then my hours for the season will be finished.
I need the formula in D2 to say "Find the cell in column C that is less than 12.3 but more than zero (as the cells below C324 are blank) and display the information in the cell in column D next to that cell.
So D2 should display cell D324 or 06/06/2024.
Can anybody help?
EDIT:
My apologies, I have made an error in my calculations.
Cell D2 actually needs to show D325 as that is the first cell that has zero hours remaining and would be the day I have finished working. Cell D324 shows that I still have 2.7 hours to work the next day.
Attachments
Last edited by a moderator: