Nick
Based on the theory that Excel struggles with negative times (early), but I
guess with deliveries you would count early as 'on time', you can achieve
most of what you want with formulae. The bit that you *will* struggle with
in Excel is live, read/write capabilities. Excel doe share workbooks, but it
would not be live and it really doesn't work well.
To the lateness, use a formula like (Expected and arrival times in B2 and C2
respectively)
=IF((C2-B2)<0,0,C2-B2)
result formatted as time. Remember if deliveries are likely to be days late
sometimes, you will need to have a date column also. (If this happens, add
the date and time columns for expected and arrival first and then subtract
one from the other), eg
=IF(((C2+D2)-(B2+A2))<0,0,(C2+D2)-(B2+A2))
For the standing time, just take the departure from the arrival (Say H2 and
F2)
=IF((H2-F2)<0,0,H2-F2)
formatted as time...
Hopefully this is a start
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS
"Nick Cartwright" wrote in
message ...
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