Adding a list of Times to a worksheet

  • I want to add a list of time ranges to a worksheet.
    8:00 - 8:30
    8:31 - 9:00
    9:01 - 9:30

    How can this be done easily in excel?

    Again thanks in Advance

  • Create a custom List

    Tools|Options - click on Custom Lists tab & create your list

    If you have the list already typed in a range of cells you can import it to the new list

    Then, by typing the first list entry in a cell, you can "autofill" the rest of the list to save you typing it again...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!