Freelancer:
freelancersree24
Solution - Formula Based
A formula which calculates based on column value D is provided. If the Bank Holiday column is "Yes", the value will be *2, otherwise it takes the value from the hours column. Please let me know if any modifications needed. Can share the excel sheet with the formula if you are interested