Time Sheet Calculation - Adding a Condition

[meppwc]

I have a spreadsheet that I use to track punch in/out as a work time sheet
Entries from B9 through E9 are my clock in/outs (Format is 8:00 that equals punch in at 8am)
In Cell F9 I have the following formula
=IF(COUNTBLANK(B9:E9)=0,(C9-B9)+(E9-D9),"")
The F9 formula tallies up B9-E9 and gives me the number of hours that I worked for that day
This formula works correctly
I would like to modify it to allow an additional condition in the event that I take a paid day off
If F9 is blank, then populate F9 with the value in I9 (the amount of total hours for a given day)

No matter which way I add this new condition to the formula it does not provide the expected result.

 

[ryan0521]

How would you know if it's a paid day off. give sample data.

 

[meppwc]

If there are no entries from B9-E9, then F9 is blank.............so for this day in I9 I would make an entry of 8:00 which is the total hours I would be paid for as a paid day off. That entry of 8:00 in I9 would need to appear in F9 as total hours paid for that particular day.

 

[meppwc]

I just got it to work
=IF(COUNTBLANK(B4:E4)=0,(C4-B4)+(E4-D4),I4)