time calculation in ACCESS

#1 April 2nd, 2005, 03:55 PM

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 & God Bless,

Jimenda

#2 April 2nd, 2005, 04:45 PM

See:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jimenda" wrote in message
...
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 & God Bless,

Jimenda

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access minimum time calculation	melric	Setting Up & Running Reports	1	April 10th, 2005 05:26 AM
Access time range query w/user input prompt and SQL datasource	MRFannon	Running & Setting Up Queries	2	November 2nd, 2004 03:30 PM
automate access form patient name, date field, time to outlook app	serverrunner	Using Forms	0	July 27th, 2004 03:59 AM
Outlook 2003 Terminal Server Time Zone issue	Robert Strom	Calendar	2	May 26th, 2004 10:50 PM
time calculation	David McRitchie	Setting up and Configuration	2	March 28th, 2004 09:14 PM