If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
time calculation in ACCESS
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
|
|||
|
|||
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 | |
Display Modes | |
|
|
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 |