>evan thank you...yes that qould worl if field one is < field 2 and they are within the same day...what about when
>strttime is and endtime is
>235600 and 010413 what do i do....

Then I would datetime fields. Subtraction is then simple.

datetime2 - datetime1