Recent content by gayansam

thank dear..

Thanks Dear RainLover it's correct

Dear RainLover, It's here

Thank Sir, It's correct I included the date, Thanks, Gayansam

This may database, thanks

Dear CJ_London Thanks for the information, however 20:00 and 8:00 result was (-12 h) minus that's why I don't know, I need to calculate two shift day and night, day shift 8:00 to 20:00 and night shift 20:00 to 8:00, some time some people worked 24hours, I made it in Excel because I need to make...

Dear All, I need to calculate work hours, My code is Round(DateDiff('n',[Out_T]-[In_T],1)/60), Because 8:00 to 22:00 result was 10 hours, what is wrong can you help me... Thanks Gayan

Thanks RainLover, Because result was (-) minus, so I made it in Excel because I need to create in Access, Thank you.

Dear all, How to calculate two between Time, Day shift is In time 8:00 and out time 20:00 then Night shift is in time 20:00 to 8:00, how to calculate them I don't know Please help me Thank you :banghead: