IF function issue involving blank cells

Guys,

I feel dumb so bear with me. I was once pretty good with Excel but I really am struggling here with something I feel is very basic. Here's my issue:

Column D is Date In (Date format)

Column E is Due Date (Date format)

Column F is Time Allotted (General format)

So what I have so far is as follows:

Please Login or Register  to view this content.

- this works fine. But I like to copy the formulas down to cover many cells, and if I have no dates in columns D or E, I want column F to be blank.

Attached is a screen shot of my worksheet...
Capture.JPG

Thanks.

Originally Posted by FlameRetired

Hellow brianb80. Welcome to the forum.

Please try.

Formula:

Please Login or Register  to view this content.

Thank you so much! For the welcome and the answer!