*Help* Time calculation problem

R

Robert

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])))))
 
K

Kevin Saccullo

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TimeStamp Calculations are wrong. Date Diff 1
Select Subquery Error 3
Time Calculation 1
Date Calculation Question for Macropod 6
TIME field calculation help please 3
Help! Trouble converting values with IIF statement 2
Need help with calculation if field is null 6
Time Calculation 9

Top