Hiding #Value! error

[TheSinghGarry]

Good Day All,

Working on a custom staff schedule. I select the start and end time and it calculates the time worked using the MOD formula. In the time list I have also added VAC to reflect time off. However as it is obviously not a number or time, its returning the #Value !.

<img src='https://i.imgur.com/kdgxHLG.png' />

I have two questions with this if anyone can help.

1. First is obviously getting rid of the Value error.
2. Second is if employee works more than 5 hours, they get a half hour unpaid break. How can I incorporate that in this?

Thanks a lot in advance. First time using this forum.

Garry

 

[alansidman]

consider wrapping your formula in one of the following functions.

iserror
iferror
iserr

Look at Techonthenet.com to see how each behaves.

 

[mole999]

=iferror(mod(b6-b5,1),"")