Calculating travelling time
Posted by F. Jager on September 13, 2001 7:09 AM
Hello,
I'm having the following little problem.
Employees of the company I work for are visiting companies who are using our computer resources.
At these companies they check a number of things.
The number of visited companies vary from day to day,
They have to keep a record of the time they spend at the companies involved and they also have to keep a record of the time they travel between the various companies.
They record their "checking" and traveling time as follows.
Company number Start time End time Travel
100 (Cel E12) 10:00 (Cel F12) 11:00 (Cel G12)
200 (Cel E13) 12:00 (Cel F13) 13:00 (Cel G13) Cel H13
300 (Cel E14) 14:00 (Cel F14) 15:00 (Cel G14) Cel H14
(Cel E15) (Cel F15) (Cel G15) Cel H15
(Cel E16) (Cel F16) (Cel G16) Cel H16
The travelling time after company 100 is visited is calculated as follows, F13-G12 and the result is placed in cel H13.
The travelling time after company 200 is visited is calculated as follows, F14-G13 and the result is placed in cel H14.
These formulas are placed (copied) in Column H in the entire "Timesheet".
The formula in cel H15 would give an error (formula F15-G14) because cel F15 is empty.
Does anyone know how to fix this little problem ?
Or maybe there is a different way to get the traveling time ?
Any help would be very appreciated.
Best regards,
Frits Jager
Posted by Aladin Akyurek on September 13, 2001 7:30 AM
Frits,
In H13 enter: =IF(COUNT(F13,G12)=2,F13-G12,"")
Custom format H13 as [h]:mm and copy down as far as needed.
Aladin
=================
Posted by F. Jager on September 17, 2001 12:43 AM
Hello,
>In H13 enter: =IF(COUNT(F13,G12)=2,F13-G12,"")
>Custom format H13 as [h]:mm and copy down as far >as needed.
Thank you very much for your help. :-)
I already used your formula, everything works perfectly now.
Thanks ! :-)
Best regards,
Frits Jager
