How about using the IFNULL function.... (IFNULL(UTIL_STOP-UTIL_START,2400,UTIL_STOP-UTIL_START)) Dawn
-----Original Message----- From: Nielsen Midge D Contr 388 RANS/JT3 [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 4:39 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Null times I tried that too. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Sent: Tuesday, 24 August, 2004 14:32 To: [EMAIL PROTECTED] Subject: [RBG7-L] - Re: Null times Midge, SET EQNULL ON Have fun! Very Best R:egards, Razzak. At 02:08 PM 8/24/2004 -0600, Nielsen Midge D wrote: >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),(U >TIL_ 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?
