Calculating Elapsed Time > Subtract 30 minutes?
by pietlinden » Sat, 02 Dec 2006 08:32:16 GMT
Robert T wrote: > I have a simple flat file form that tracks my time at work, and except for > one minor problem, it works perfectly. The two relevant time fields are > [Start_Time] and [End_Time]. The calculated expression for [Total_Time] is: > > =HoursAndMinutes([End_Time] - [Start_Time]) > > The above expression works, however, I need to subtract 1/2 hour [30 > minutes] from the above calculation because that's my lunch time. I thought > it would take only a few seconds to make the change, but it's proven to be > far more difficult than I thought. I searched on the HoursAndMinutes() > function but couldn't find any relevant information. > > Thanks, > Robert Robert, 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 use DateAdd("n",-30,[SomeDate]) 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53