Time Calculations

[lanmark17]

My dilemma -
I need to track timesheet data and calculate the difference in times in vs
times out. An employee swipes a time card 4 times a day. I need to calculate
the total hours worked subtracting the lunch time out to get total hours
worked in the day.
I have a form and a subform which I can enter all 4 time swipes. I have been
able (using "hoursandminutes") to calculate the total work hours in one field
and total lunch hours in another field. I am unable to subtract the Lunch
times from the Work times. I also have "summed" fields in my main form, which
keeps a running tally of Worked times and Lunch times. Example below.

My data
StartIn LunchOut LunchIn DayOut DayTotIn DayTotOut
9:46AM 2:33PM 3:08PM 5:48PM 8:02 0:35

DayTotIn is the calculation of [DayOut]-[StartIn]
DayTotOut is the calculation of [LunchIn]-[LunchOut]

All that works well. I just can't get the calculation of
[DayTotIn]-[DayTotOut]

I have all this worked out in Excel. I just can't get it worked out in
Access. Please help. Thanks!

 

[Jeff Boyce]

If your table is structured with those multiple in/out date/time fields, you
have a spreadsheet, not a relational database.

Furthermore, if you have "totals" in that row, you still have a
spreadsheet -- it is rarely necessary to store calculated values in a
well-normalized relational database.

If you can make this work in Excel, why do you need Access?

Regards

Jeff Boyce
Microsoft Office/Access MVP