# 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

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.

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.

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)

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

Thanks!! works perfectly.

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!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1