Hi, Im creating a worksheet for a movie theatre I want to plug in a start time for each auditorium and have it calculate all of the next 7 show times. That is easy enough but I also have to spred the times evenly throughout the day so I was trying to have them displayed by the hour. For example i would like the sheet to look something like this.
Aud1 aud2 aud3 aud4 aud5 aud6 aud7 aud8 aud9 aud10
9am 9:25 9:45 9:10
10am 10:05 10:50 10:20 10:30
11am 11:00 11:15 11:30
12am 12:30 12:05 12:00
1pm 1:00 1:55 1:20
2pm 2:45 2:00 2:15 2:40 2:10
Any help would be greatly appreciated.
Bookmarks