Hi all,

Please help us to solve this problem..Im working in the time and attendance system then i encounter error in computing ng total hours..Iam using datediff, " BEFORE_OT = DateDiff("n", #6:02:00 AM#, #12:20:00 PM#)" and result is 8 hour...so my question is how can i include the minutes in the computation using date diff??in my computation the right result is 6.18 hours..please advise,thanks

You will need to take care regarding crossing midnight.