I have a database that I am converting to 7.x from 6.5++. I let the user input utilization times if a mission is complete. If they insert a utilization start time, but not a utilization stop time or vise versa, the remaining time is inserted as a null value.
I compute the utilized hours by the following formula, so that the number of hours is always positive. Util_hr = (IFLT((UTIL_STOP-UTIL_START),0,(((UTIL_STOP-UTIL_START)+86400)/3600),(UTIL_S TOP-UTIL_START)/3600)) R:Base 6.5++ looks at the missing time and assumes it is 2400 hours, which is correct. R:Base 7.x looks at the time as null and does not compute a utilized hour. Can anyone help me figure out how to get it to compute the utilized hours?
