Time Calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am still learning about access. I am designing a database that will create
schedules for employees. I have time in (Med Time) timwe out (Med time)
Break time (short time). These corrispond to the t days. I then have a
total hours spot that will sbutract time out - time in - break time. The
problem is adding the total hours for each day to have a total worked hours
for the week. How do I do that?
 
Hi,
you can calculate hours using datediff() function, it will return an integer
number of hours, which you can easy sum
 
I am in the Expression Builder and when I click on the Datediff is see this:
DateDiff («interval», «date1», «date2», «firstweekday», «firstweek») What do
I plug into the interval etc? The only field I have is the totla hrs fo each
day the name of the first one is SatAdjBal
Thanks for your help.
 
I got it! You are good thanks for the help.

Alex Dybenko said:
Hi,
DateDiff("h", [time in field],[timwe out field])

--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


Erik said:
I am in the Expression Builder and when I click on the Datediff is see
this:
DateDiff (<interval>, <date1>, <date2>, <firstweekday>, <firstweek>) What
do
I plug into the interval etc? The only field I have is the totla hrs fo
each
day the name of the first one is SatAdjBal
Thanks for your help.
Click to expand...
Click to expand...
 
Back
Top