Spreadsheet advice

[nickyboyc]

Hi guys,

I'm not sure where to post this but I'm looking for some assistance/guidance
on what to do with a spreadsheet we are current'y using.

We use a 'booking' sheet at work which has a series of colums which has
fields such as booking ref,booking time,arrival time,departure time etc... of
the vehicles that have been in and out of our warehouse.

What we require is for this spreadsheet to become a little more 'advanced'
and be a little easier to use and also generate reports for example :

Vehicle 1 for customer A had a booking time of 09:00, it didn't arrive till
09:45 and left at 10:15.

We'd like for that 'Customer' how many booking slots were missed and by how
long and they how long it took for the vehicle to leave in this case it would
have been :

45 minutes late
30 minutes 'turn around time'

Also one of the main things we require is multiple users can see/edit live
data which is not possible at the moment.

You can find the spreadsheet here on my webspace
http://www.nickyboyc.force9.co.uk/BOOKING.xls

Any thoughts and suggestions will be very much appreciated

Many thanks in advance
Nick

[barijohn]

You could just use a simple formula for that. Inser extra colums for where you would like them.

=booking time - arrival time
=D5-E5

=departure time - arrival time
=F5-E5.

You need to make sure the time is inputted in 00:00 format.

You can Share a workbook which allows multiple users to do what you require. On the Tools menu, click Share Workbook, and then click the Editing tab.

Select the Allow changes by more than one user at the same time check box, and then click OK. When prompted, save the workbook.


On the File menu, click Save As, and then save the shared workbook on a network location where other users can gain access to it.

HTH