Displaying zero instead of #VALUE!

[suxrule]

Hi,

I'm trying to get my #VALUE! error to just display zero.

I've included 3 examples of whats happening with the formula I'm using.

The two red cells are obviously not what I want to happen and the green one is my desired result.

My problem is #VALUE! is displayed when I enter anything other than a number, I'd just like to display zero. You'll see what I've tried in B4 is to use IFERROR but to be honest I'm not 100% sure what I'm doing, I'm just searching the internet and trying to figure it out as I go.

Basically I want ((end time - start time) - break time)

(I've just spent about half an hour trying to get the Mini-Sheet working on a Mac and I'm getting no where so it's pictures I'm afraid, sorry)

Any help much appreciated.

Desired output (but display zero if anything other numbers are entered)

 

[mamady]

You were close. Please try the following formula:

=IFERROR(((I3-H3+(I3<H3))*24)-J3,0)

Regards

 

[suxrule]

Thanks so much!

I've asked 2 questions so far on here and I'm sure both are very simple to most but I've been met with nothing but polite help.

Other platforms can be a bit judgy when you ask a simple question (StackOverFlow for example ?) anyway thanks again.

 

[mamady]

Thanks so much!

I've asked 2 questions so far on here and I'm sure both are very simple to most but I've been met with nothing but polite help.

Other platforms can be a bit judgy when you ask a simple question (StackOverFlow for example ?) anyway thanks again.

it is my pleasure to help

Regards