Timetable Database

[SysX]

I'm trying to create a database for a simple process that involves transport stopping at set points and costing x dollars from point a to b and xx dollars from points b to d etc with varying routes.

 

Route A

 

Points Time Cost (from points a to e =total cost $10)

a 10:00 -$0

b 10:15 -$3

c 10:40 -$4

d 11:20 -$6

e 12:00 -$10

 

I want a person using my website to be able to select a point to be picked up at x time (relating to route x) from and dropped off at point xx and the database to give them the total cost and length of the journey + the pickup and drop off times.