Search results

  1. N

    Convert Excel function to Access either with VBA or function

    Hello All, I need a function or vba code count the serial number which are re-appeared within 30 days. I have attached an excel sheet with 2 resolution one using Countifs function other one using arrays. I am not able upload the xlsx version hence i have uploaded xls version. But I want...
  2. N

    Add 2 Hours To Date Value With Working Hours Condition in Access 2007

    Hello all, I want to add 2 hours to Start Date/Time to get the Target Time, with the Condition of working hours. Let me explain with examples: Workings hours 8:00 AM to 5:00 PM Examples 1) Start Time : 7/13/2012 8:48 AM adding 2 hours will result 7/13/2012 10:48 AM 2) Start Time : 7/13/2012...
  3. N

    Question Add 2 Hours to Date Value with Working hours Condition

    Hello all, I want to add 2 hours to Start Date/Time to get the Target Time, with the Condition of working hours. Let me explain with examples: Workings hours 8:00 AM to 5:00 PM Examples 1) Start Time : 7/13/2012 8:48 AM adding 2 hours will result 7/13/2012 10:48 AM 2) Start Time : 7/13/2012...
  4. N

    Need help in adding hours to Date & time with Working hours condition

    Hello All, Need a help on the below condition. Working hours : 9:00 AM to 5:00 PM Example 1: Starting Date : 8/1/2012 9:31 AM Expected Result: 8/2/2012 5:00 PM Example 2: Starting Date : 8/3/2012 9:31 AM Expected Result: 8/6/2012 5:00 PM Example 3: Starting Date : 8/1/2012 5:31 PM Expected...
Back
Top Bottom