London Transport (uk.transport.london) Discussion of all forms of transport in London.

 
 
LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #11   Report Post  
Old April 14th 04, 10:09 PM posted to uk.transport.london
external usenet poster
 
First recorded activity at LondonBanter: Apr 2004
Posts: 179
Default Train Timetables in MS Excel format

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Parking at ExCel eastender London Transport 4 April 30th 07 10:10 AM
Free parking near Excel in Docklands ? Mike Day London Transport 0 March 25th 05 07:48 PM
TFL Timetables for PDA Pocket Journey Planner Matthew P Jones London Transport 1 December 20th 04 12:55 PM
New Met line timetables daveb London Transport 18 May 24th 04 06:16 PM
New Route 83 Timetables Lawrence Myers London Transport 9 April 18th 04 02:33 PM


All times are GMT. The time now is 01:58 AM.

Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 London Banter.
The comments are property of their posters.
 

About Us

"It's about London Transport"

 

Copyright © 2017