Posts by bonsmara

    Re: Rearranging timetable data

    Hi Fuzz-Head,

    Thanks for the reply. Do you mean you need a sheet with at least two tabs with timetables as attached (timetable example.xls)? You will see on the attached spreadsheet that there are a top and bottom table on the tabs which is compiled like this for easy printing. In some cases the top table is the "forward" trips and the bottom the "reverse" trips.

    Just on the time issue: is it possible to do it on 24hr format in stead of adding am/pm?

    Hope this will assist.




    I have a challenge with a public transport timetable (file "New Timetable" attached). In the attached file there are two tabs "Zone 3 to Pta" (this is an example of how the timetables currently look like) and "Solution" (the format in which I now need it - I only included 3 lines as example). The timetables can contain more columns as well as rows. As can be seen there are various numbers of "intermediate points with arrival times attached.

    What is important (and I don't know whether it is possible) I need the name on the tab as part of the "Solution" as shown in Column A.

    I need to do this for between 50 and 100 timetables of a similar format and by hand it will take days.

    Is it possible to write a macro which will convert the info from the one format ("Zone 3 to Pta") to the new format as shown on "Solution"?

    Your guidance and assistance will be appreciated.