Search results

brother! thanks! finally got it right! thanks a lot!

:D Hey pal! After trying so many methods to calculate the date/time difference, should say a bit thank you to you! Had achieve the results required. but is it possible for the results return format to be should in hours and mins alone? had tried several ways to change the 00:03:00 format to 03...

:) Hey pal, had tried your queries code, however encounter a problem here. Assuming the following values are in the fields. [job completed time] = 03/05/2005 01:30 AM [job start time] = 03/04/2005 09:30 PM Time difference between these 2 date/time should be 4hrs. But with your code, it gave...

Hi pal, I tried using the above said method to calculate the time difference, however I encounter a problem. The following are the values in the fields. TimeIn = 2330hrs TimeOut = 0130hrs If we were to count the number of hours logically, we will get back 2hrs difference. But if I were to use...

Hi all, would appreciate if you guys could help me out. I'm new to MS Access 2002 and currently had a project going on. Currently, I have 2 fields. "DateTime_Out" and "DateTime_In". I would like to calculate the days and time difference in the 2 fields as in [DateTime_IN]-[DateTime_Out] giving...