MS Access Report Problem.

[Imran Jalali]

Dear Friends,

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?

Thanks.

Imran Jalali.

[maanhajrachid]

hello

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