+ Reply to Thread
Results 1 to 3 of 3

Help sorting times

  1. #1
    Registered User
    Join Date
    03-24-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Help sorting times

    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.

  2. #2
    Registered User
    Join Date
    03-24-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Help sorting times

    well the post doesnt look exactly like I would like so the auditorium numbers on top and the 9am 10am 11am and so on on the left like a chart and then the start times below the auditorium number but in the cloumn of the corect hour.

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,596

    Re: Help sorting times

    Use CODE (a # sign above) and paste there.
    But you would also need to put more informations what you have and what you want.

    If you have example please upload it too.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1