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

[amac4556]

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

[63falcondude]

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.

[63falcondude]

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.

[finalazy]

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)

[amac4556]

Thanks!! works perfectly.

[63falcondude]

You're welcome. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.