Need way to calculate time worked in a day minus lunch break 1

[xwizardx]

CONSIDER:
four fields:
[TimeIn] = 8:30
[TimeOut] = 16:00
[LunchOut] = 12:30
[LunchBack] = 13:15

The times will vary with the record being processed.

Is there a function or procedure that I can use to fill a 5th field: [TotalTimeWorked]?

Thanks

Barry Davis, President
Small Business Computing, LLC

 

[dhookom]

Typically you would not store a value that can be calculated. If you really think you need to store a value that can be calculated on the fly then try something like the following to get the minutes:

=DateDiff("n",TimeIn, LunchOut) + DateDiff("n",LunchBack, TimeOut)

or

=DateDiff("n",TimeIn, TimeOut) - DateDiff("n",LunchOut, LunchBack)

This assumes all fields will have values

Duane
Hook'D on Access
MS Access MVP