Hi there, I am quite new to excel and currently have a list of times like this below for a timetable schedule. I am looking to have a formula that applies different iterations between each cell below depending on whether it is peak or off-peak hours.
Peak hours = 7:30am to 9AM and 4:30PM to 6:00PM
Off Peak hours = 9AM to 4:30PM and 6:00PM to 9:00PM
Basically, in peak hours the change in time should be every 15 minutes and off peak should be every 30minutes. The 15 and 30 minutes are defined in two other cells so it would be ideal if the formula would alter depending on the times in those cells, for example, if we wanted to change to every 10 and 20minutes etc.
Any help would be appreciated and hopefully my question is clear.
Peak hours = 7:30am to 9AM and 4:30PM to 6:00PM
Off Peak hours = 9AM to 4:30PM and 6:00PM to 9:00PM
Basically, in peak hours the change in time should be every 15 minutes and off peak should be every 30minutes. The 15 and 30 minutes are defined in two other cells so it would be ideal if the formula would alter depending on the times in those cells, for example, if we wanted to change to every 10 and 20minutes etc.
Any help would be appreciated and hopefully my question is clear.
| 6:00 |
| 6:30 |
| 7:00 |
| 7:30 |
| 7:45 |
| 8:00 |
| 8:15 |
| 8:30 |
| 8:45 |
| 9:00 |
| 9:30 |
| 10:00 |
| 10:30 |
| 11:00 |
| 11:30 |
| 12:00 |
| 12:30 |
| 13:00 |
| 13:30 |
| 14:00 |
| 14:30 |
| 15:00 |
| 15:30 |
| 16:00 |
| 16:30 |
| 16:45 |
| 17:00 |
| 17:15 |
| 17:30 |
| 17:45 |
| 18:00 |
| 18:30 |
| 19:00 |
| 19:30 |
| 20:00 |
| 20:30 |
| 21:00 |
