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.

"KEK21" wrote:

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