+ Reply to Thread
Results 1 to 3 of 3

Help sorting times

Hybrid View

BIG WILLAGE Help sorting times 03-24-2009, 05:22 AM
BIG WILLAGE Re: Help sorting times 03-24-2009, 05:25 AM
zbor Re: Help sorting times 03-24-2009, 05:27 AM
  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
    16,054

    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.
    Never use Merged Cells in Excel

+ 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