If it is stored as military time (ie. 0330) in a character field, couldn't you take the VAL(LEFT(time,2)) and substract 4. If the value is less than 0, then it would be the previous day and you would need to adjust for it, maybe by adding 24 (eg. -3 + 24 = 21 which is 9PM the previous day)...