Home |
Search |
Today's Posts |
![]() |
|
London Transport (uk.transport.london) Discussion of all forms of transport in London. |
|
LinkBack | Thread Tools | Display Modes |
#11
![]() |
|||
|
|||
![]()
I've been asked to produce a series of Excel spreadsheets with train
timetable information for a number of National Rail (London only) routes. Besides using the Network Rail journey planner and manually typing/pasting them in, is there any way of getting this information into Excel? It's getting a bit complicated and time consuming! Thanks, David. With trains which are at all regular there is the addition trick: For a regular 15 minute interval, say, you could type something like: =b2+(15/1440) in cell c2, then cut and paste as required. If a station is always, say, 3 minutes on from the previous one, you could use: =b2+(3/1440) in cell b3, then cut and paste as required. The important step is to set the number type in the cells to hh:mm, then remember the colon as you enter each point! With these things done, it's lighter work, but it's still a bit of a challenge. If you like, e-mail me ) and I'll send you a sample of a fantasy 2 hour period on the Midland Main Line I've created for totally different purposes. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Parking at ExCel | London Transport | |||
Free parking near Excel in Docklands ? | London Transport | |||
TFL Timetables for PDA Pocket Journey Planner | London Transport | |||
New Met line timetables | London Transport | |||
New Route 83 Timetables | London Transport |