View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark Mark is offline
external usenet poster
 
Posts: 989
Default Formula/Comparison/Match Question

Spreadsheet with 2 columns, first has site name, second has time taken to
make a delivery to that site (In decimal)
So for instance
A1 = London B1 = 2.10
A2 = Birmingham B2 = 4.60
A3 = Edinburgh B3 = 6.70

etc,etc

Is it possible to build a formula that will take the data in column B and
work out which deliveries will go together to form a working day of no more
than 11.00 hours?

Mark