Time Study

[wforst]

Hi,
I have been doing Time interval stuff and I have a cell that has blanks and I get #VALUE! in the blank cells.
The formula I am using for my time stuff is =J2-E2+IF(E2>J2,1). My results are being displayed in cell T.
I saw somewhere that you can add if 0,"",1 but I can not get it to work.
I need help.
Thank you very much
Bill Forst

[arthurbr]

I suppose you mean =J2-E2+(E2>J2) ( to add 24 hours)

[wforst]

No I am using
=J2-E2+IF(E2>J2,1)

[arthurbr]

What are you trying to achieve ? the condition (E2>J2) will result in 1 if condition true and 0 if False. The IF is therefore not needed

[wforst]

Here is the file I hope

[wforst]

I am trying to get colum P to not show #VALUE! because of the blank cells, my time seem to be correct.

[arthurbr]

You get an error when the cell in col F is empty. What do you want in the place ? A blank cell ?

In this case try

Please Login or Register  to view this content.

PS; again, the IF function is NOT needed, you are making the sheet heavier than needed

[wforst]

That makes all the cells blank.

[arthurbr]

It works for me ( see attached)

[wforst]

Ok Got it to work thanks.