Formula Help

[KEK21]

I am wanting to calculate someone's travel time. In column a I have the
departure time. I want to add travel time to the departure time in column a.
The text in column b will determine the amount of time to be added. If
someone leaves from location a and it takes 30 mins I want to recognise the
name of location a and automatically insert the arrival time.

column a = departure time (time format)
column b = location name (text)
column c = arrival time

 

[muddan madhu]

might help u ...........

col A Departure time
col B Loction name
Col C arrival time

u need specify what's the time the different location ....

for this i have taken from example as
col E location name Col F time
A 30 min
B 35 Min
C 40 Min
D 50 min

put this formula in C2 =LOOKUP(A2,$E$1:$E$4,($F$1:$F$4)+A2)

 

[Zorrina]

Hi,

1) Define the time for each location first (maybe in another worksheet -
say, worksheet 2)
Worksheet 2: Column A - location, Column B- Time

2) Worksheet 1: Column C = Time in column A + vlookup of location in Column
B from worksheet 2. You may need to convert the time obtained through vlookup
from minutes to hours before adding.