Forum Discussion
Finding an appointment in Excel
Hi there, I got a question for you. Imagine, in columns B and C I have the dates and times of my appointments. As you can see, I have two appointments per Sunday. Now, how can I in column G create a ...
Deleted
Here is a first attempt. It may need additional tweaking.
Do not change the formulas in column D.
Exactly! (As there are 5 hours or more between 07:00 and 12:00 and between 12:00 and 17:00.)
Deleted
Here is a first attempt. It may need additional tweaking.
Do not change the formulas in column D.
- This is just awesome, thank you so much for your effort!