Subtract 30 minutes

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