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)
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)