Calculations in an update query

[gemz]

ok, i am setting up a database for an a level project and everything has
gone fine so far. but now i have come to doing an update query. what
i have is the following fields: Employee ID, week starting, Monday - In
, Monday - Out, Tuesday - In etc through to Friday - Out and Total
hours worked. what i want the update query to do is take the time the
employee clocked in and take it from the time they clocked out for each
day, then add all these up to get a total number of hours the employee
has worked for that week. everything is fine till i get to Wednesday
and go over 24 hours then it all goes wonkey coming up with a random
date and a random time. the way i have tried to do this is using the
following formula: ([Hours In and Out Table]![Monday-Out]-[Hours In and
Out Table]![Monday In])+([Hours In and Out Table]![Tuesday-Out]-[Hours
In and Out Table]![Tuesday-In]) etc......

if anyone could help me on this then i would be very grateful..

 

[Duane Hookom]

You are committing serious 'spreadsheet'. Your dates should be values in a
"WorkDate" field rather than a field name. I wouldn't do anything further
without changing the tables to a normalized structure. Is it possible for
you to change the structure?