I have several equations in a query that converts time to different formats. I have another query that subtracts one of the equation values from a view, and then displays on a form. Works great unless one of the fields used for the equation happens to be null. The problem is that one of the two fields will always be null (time in and time out) for a given period of time.
How do I have the equation to ignore the nulls but provide the information for the rows that contains both fields?