Sunday, 15 July 2012

Excel - Adding time due to specific value -


I need help in formulating Excel formulas. I want a formula for viewing the value in a cell. If the price is "telephone", then I want to add it 5 minutes to my timeline. If the value is "email / fax", then I want to add it 2-1 / 2 minutes. Please help?

Say that the time passed is in A1 and the text is in the cell < Enter strong <1> , 5,0)), if (b1 = "email / fax", a1 + time (0,2, 30), a1))


No comments:

Post a Comment