Working on time and motion study in excel 2003. Need a function to recognise data as a letter e.g. A = Admin, E = Email etc then multiply by time (as in 5 min to each task). Unsure if VLOOKUP and TIME correct functions to use and how to set up.