#value to 0 with schedule using start time end time

[flapjack1803]

I have this formula that calculates hours worked minus lunch break for 6 or more hours. However, I have some cells that have text instead of numbers and I get the #value error. What can I add to this formula to just zero out the #value error?

The formula is: =IF(C4-B4<1/24*5,C4-B4,C4-B4-1/48)*24

I appreciate any help!
Thanks!

[Harribone]

Wrap formula in an IFERROR:

Please Login or Register  to view this content.

"" will leave the cell blank, change to 0 if thats what you want to display.

[flapjack1803]

Great, that worked! Sometimes you can work on a problem so long, you miss the obvious! Thank-you!