## Forum Discussion

MarkShnier__You

3 years agoQrew Legend

One way to fix this is to fix the [Lunch Formula] field so that it calculates to a zero instead of a blank when the employee did not take a lunch. But if you want to kind of patch your existing formula you can do this

The function Nz (.....) Will convert any Null values into a numeric Zero

------------------------------

Mark Shnier (YQC)

mark.shnier@gmail.com

------------------------------

**Total Day Worked=**[Time Worked Formula] -**Nz(**[Lunch Formula]**)**The function Nz (.....) Will convert any Null values into a numeric Zero

------------------------------

Mark Shnier (YQC)

mark.shnier@gmail.com

------------------------------

- CassieHubble3 years agoQrew CadetThanks, Mark that worked perfectly!

------------------------------

Cassie Hubble

------------------------------