Norman Fite
asked on
How to auto fill a column with a given start and end time, In 15 minute increments
I am doing a schedule.
Time - Duration - Name
Another Learning exercise for me..
I have 3 Combo Boxes with Start Time, End Time, Duration.
By Selecting the days start time I will fill the Time Column Starting with selected TIME to End Time.
For Duration, My Combo Box, is setup with 15 minute increments. 15, 30, 45, 60, (which I will extend to additional time later).
1. What I would like to try See Attach;
Start time = L3, Then autofill the time down Column L to Selected End Time/ but each Cell is = 15 minutes. So an 1 hour appointment cells M3 to M4 would be Filled.
And the conditional formatting of the Duration cells is or was the question. How would I use Conditional formatting or VBA to fill the corresponding cells under Duration, when each appointment is selected:
ScheduleLearn.xlsx
Time - Duration - Name
Another Learning exercise for me..
I have 3 Combo Boxes with Start Time, End Time, Duration.
By Selecting the days start time I will fill the Time Column Starting with selected TIME to End Time.
For Duration, My Combo Box, is setup with 15 minute increments. 15, 30, 45, 60, (which I will extend to additional time later).
1. What I would like to try See Attach;
Start time = L3, Then autofill the time down Column L to Selected End Time/ but each Cell is = 15 minutes. So an 1 hour appointment cells M3 to M4 would be Filled.
And the conditional formatting of the Duration cells is or was the question. How would I use Conditional formatting or VBA to fill the corresponding cells under Duration, when each appointment is selected:
ScheduleLearn.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, this will get me started.
I was looking for a how to; which you showed me.. After going through your solution, I have implemented using minutes in the duration time and removed the shading component and I am using -- to signify unavailable time.. Looks much better, using minutes my later calculations are much less confusing..
Thank you again, great job..
Norm Fite
I was looking for a how to; which you showed me.. After going through your solution, I have implemented using minutes in the duration time and removed the shading component and I am using -- to signify unavailable time.. Looks much better, using minutes my later calculations are much less confusing..
Thank you again, great job..
Norm Fite
ASKER
I am relatively new at VBA, So I don't have preferences, I am learning. I am always open to suggestions and instructions.
What I sent as an attachment, was or is the way I try to think and outline what I am trying to accomplish. So it is in no way a final anything. That being said... suggest away...
Thank you for your time,
Norm