Adding a list of Times to a worksheet

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


    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!

Register Yourself Login