Recent content by naveensg

pr2-eugin, Thanks for looking into my request, If serial number re-appeared within 30 days irrespectve whether its same month or not?, we need consider the second one as duplicate. Ex: L3AAB8Y - 350M, when it first appears it will be called origianal, the later appears within 30 days from...

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...

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...

John, This DateAdd() function works like Sum function like adding 2 hours for any particular time. But what about working hours & working day condition? this function does not satisfy these conditions. Regards, Naveen

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...

Hello Sir, Thanks for the Code, however it's not working in all conditions. Its considering the latest If Condition to calculate End Time. Regards, Naveen

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...