Mar 9 2005, 04:11 PM
I am working on a punch in punch out feature for a projects db I am working on & I can not figure out how to calculate the hours between the check out date & check in dates. Any ideas or snippets?
Mar 9 2005, 04:26 PM
Use the DateDiff() function to return the elasped time ...
Try the DateDiff function, assuming your check in and check out dates are actual date/time values.
DateDiff("h", CheckIn, CheckOut)
Mar 9 2005, 04:49 PM
That works perfect! One more quickie, how do I get it to be a positive num instead of a negetive?
Mar 9 2005, 05:23 PM
You need to reverse your date values in the function arguments ...
The start date/time is should be first .. then the end date/time ..
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here