Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Move multiple rows of data that are not sequential | Excel Discussion (Misc queries) | |||
Is Office Clipboard shared between users or just applications? | Excel Discussion (Misc queries) | |||
External Links and Multiple Instances | Excel Discussion (Misc queries) | |||
selecting multiple sheet tabs and open another workbook | Excel Discussion (Misc queries) | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) |