Calculating time in ACCESS

[Jimenda]

Part of my Db is a time clock type system in which my employees "clock in" and "clock out" of lunch and the workday. Is there a way that I can work with these timestamps (formatted as HH:MM) where I can calculate sums with the existing data? Being that it is base on 60 minutes to the hour I am having some trouble with this.

Thank You,
Jimenda

 

[Eupher]

When you say "formatted as HH:MM" do you mean formatted with the format function? If so, remember that the format function returns a string value, so would be difficult to use in math computations. If you haven't already, take a look at the DatePart function.

Ken S.

 

[Eupher]

p.s. Also take a look at DateDiff and DateAdd.

HTH...

Ken S.

 

[Eupher]

And here's a link that might prove helpful:

http://allenbrowne.com/casu-13.html

Ken S.

 

[Eupher]

One more. Here's a link to a Microsoft download page for a sample DB with time calc functions:

http://www.microsoft.com/downloads/...46-80a4-4913-b18f-2cbc96bf03ea&displaylang=en

Once again, HTH...

Ken S.