MS Access Report Problem.
I have a report in MS Access, in which I have four cols.
EmployeeID TimeIn TimeOut Late
1234 09:10:00 18:00 09:10:00 - 09:00:00
My problem is on the fourth column I must have an expression or formula
which allows me to calculate the difference of Time from the the TimeIn i.e
09:10:00 - 09:00:00, How I can create a formulate which allows me to do so in MS Access?
I know how to do in Excel and Crystal Reports but not very much familler with MS Access Reporting..
Can anybody help me?
try : DateDiff("h";[in];[out]) & ":" & (DateDiff("n";[in];[out]) Mod 60) & ":" & (DateDiff("s";[in];[out]) Mod 3600 Mod 60)
in and out are Date/time formated
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center