time difference

I have made a table having a field- clockIntime and another field
ClockOutTime --I need to know the difference between the clock in and clock
out time in my query or report.
Please reply ASAP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13827-time-difference.html

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Hi.

Use the DateDiff function to calculate seconds. You can then use that value
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13827
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13827
to calculate exact minutes, hours, days, etc.

You may also want to have a look at the Diff2Dates function located here:
http://www.accessmvp.com/djsteele/Diff2Dates.html

-Michael


"Ab" wrote:

> I have made a table having a field- clockIntime and another field
> ClockOutTime --I need to know the difference between the clock in and clock
> out time in my query or report.
> Please reply ASAP

=(DateDiff("n",[StartTime],[StopTime]))\60 &
Format((DateDiff("n",[StartTime],[StopTime])) Mod 60,"\:00")
This will show it as...
HH:MM



You can do it as just minutes if you'd prefer...
=DateDiff("n",[StartTime],[StopTime])




--
Rick B



"Ab" wrote in message
news:1E761490-6BF7-468C-BA54-ED4408FE4DB4@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13827
>I have made a table having a field- clockIntime and another field
> ClockOutTime --I need to know the difference between the clock in and
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13827
> clock
> out time in my query or report.
> Please reply ASAP