# combining multiplr formulas

#### gtho351

##### New Member
Hi Guys

I have the basic formulas however there are some tricky areas I can't seem to get to work for me

This is the normal Mon to Fri day shift formula

=24*(IF(\$D\$6>\$H\$6,\$H\$6+1-\$D\$6,\$H\$6-\$D\$6))
Is working just fine as it always has where D6 is the start time for their shift and H6 is their finish time

Mon to Fri Night shift wherethe night shift penalties start after 10pm

=COUNTIF(\$D\$6,">=22:00")*24*(IF(\$D\$6>\$H\$6,\$H\$6+1-\$D\$6,\$H\$6-\$D\$6))
Again this works fine for me

However if there is a public holiday I have tried this mix of formulas but obviously it doesn't work

=IF('Roster week 1'!E5,">=P/H"),IF(\$D\$6,">=22:00")*24*(IF(D6>H6,H6+1-D6,H6-D6))

All the above formulas are recorded in different Cells and there are different pay rates for the different times

I am hoping there is a simple way to marry all the formulas together
and that it can be added to ALL the above formulas if needed

Cheers
Bill

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Replies
2
Views
680
Replies
2
Views
213
Replies
0
Views
341
Replies
6
Views
563
Replies
2
Views
178

1,221,127
Messages
6,158,104
Members
451,464
Latest member
Holden3

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back