Forum Discussion
Solved
Excel formula - Show value in dedicated cell based on various values in multiple cells.
Hi, I would like to get some help with finding a correct formula for the following cases. Case #1 If text in A3 shows 'Monday' i would like to get the autosum of D3-C3 visible at E3. ...
See the attached sample workbook. I used a list of public holidays in The Netherlands; you can edit the list as needed.
Do you also need to take end times after midnight into account? For example
Start time = 20:00
End time = 04:00
If working over midnight (0:00) these hours need to filled out in a new row.
Example:
Working on 04.02.2022 from 20:00 to 04:00, the hours from 0:00 to 04:00 need to be filled out in new row with correct date.
Example:
Working on 04.02.2022 from 20:00 to 04:00, the hours from 0:00 to 04:00 need to be filled out in new row with correct date.
Please check out the attached version.
Hi Hans,
Thank you so much.
This is exactly how i wanted to create this timesheet but as i wrote before, i could never figure this out myself....
I appreciate your quick response and excellent help...Have a nice weekend.
Greetings Jeroen