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

## Bookmarks