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
|
|||
|
|||
*Help* Time calculation problem
For some reason, my time calculations are wrong when i run the queiries. if
it is 7am to 9pm, the calculations are wrong. But if its from 3 am to 11 am or 1 pm to 9 pm, its correct. Do I have to tell it that its a 12 hour time? here is the formula that I use: Hours: ((IIf([ClockIn]=True,Null,DateDiff("h",Nz((SELECT Max(Q.[TimeStamp]) FROM TimeClock AS Q WHERE Q.ClockIn = True AND Q.TimeStamp T.[TimeStamp]),0),[T].[TimeStamp]))))) |
#2
|
|||
|
|||
*Help* Time calculation problem
How are you entering the Time? ie as 7am / 9Pm or 07:00 / 21:00. Have you
tried using the 24 hours format to see if the output is as expected? "Robert" wrote: For some reason, my time calculations are wrong when i run the queiries. if it is 7am to 9pm, the calculations are wrong. But if its from 3 am to 11 am or 1 pm to 9 pm, its correct. Do I have to tell it that its a 12 hour time? here is the formula that I use: Hours: ((IIf([ClockIn]=True,Null,DateDiff("h",Nz((SELECT Max(Q.[TimeStamp]) FROM TimeClock AS Q WHERE Q.ClockIn = True AND Q.TimeStamp T.[TimeStamp]),0),[T].[TimeStamp]))))) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Another time addition problem | Martin B | Worksheet Functions | 2 | April 14th, 2006 08:26 PM |
Time calculation problem (URGENTProject due) | g6pack | General Discussion | 4 | November 28th, 2005 04:14 AM |
Time Problem | B. Baumgartner | General Discussion | 2 | June 30th, 2005 09:05 PM |
Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
time calculation | David McRitchie | Setting up and Configuration | 2 | March 28th, 2004 09:14 PM |