# find formula for (formula)+(*1.5 if colum A has certain word) if not use original formula

1. ## find formula for (formula)+(*1.5 if colum A has certain word) if not use original formula

i have two times of day (start of shift and end of shift) in 2 colums, then the next colum is the difference between the two times. for example
B3 14:00 C3 16:00 D3 2 - using the formula (c3-b3)*24 in D3

I Want D3 to times by 1.5 if A3 has 'sat' or 'sun' in the collum (colum A will have a day either mon-sun in it) but i want to remain the normal number of hours if it is a week day in A3

Any suggestions? the two formulas i have tried to use have been wrong as i cant seem to add 2 words to the search and i dont know how to keep with original formula working out the difference in hours between c3 and b3  Register To Reply

2. ## Re: find formula for (formula)+(*1.5 if colum A has certain word) if not use original form

Hello and welcome to the forum.

Attach a sample workbook.

Make sure there is just enough data to demonstrate your need.

Make sure your desired results are shown, mock them up manually if necessary.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.  Register To Reply

3. ## Re: find formula for (formula)+(*1.5 if colum A has certain word) if not use original form

If A3 is a text value and not an actual date that is formatted to show the day of the week, try this in D3:

=(C3-B3)*24*IF(LEFT(A3)="S",1.5,1)

If this doesn't work, we'll probably need to see a small representative sample of your data.  Register To Reply

4. ## Re: find formula for (formula)+(*1.5 if colum A has certain word) if not use original form

Just like 63falcondude said, if is not an actual date but text value in column A, you can use his method or using the OR formula.

Example like
=IF(OR(A3="sat",A3="sun"),(C3-B3)*24*1.5,(C3-B3)*24)  Register To Reply

5. ## Re: find formula for (formula)+(*1.5 if colum A has certain word) if not use original form

Thanks!! works perfectly.   Register To Reply

6. ## Re: find formula for (formula)+(*1.5 if colum A has certain word) if not use original form

You're welcome. Thanks for the rep!  Register To Reply