Hi All,
I have data as below...
Name Workshop Shift Start_Date End_Date No.of_Days_Worked No.of_Days_Total
Ravi Car Cleanup Day 01-Jan-2014 10-Jan-2014 = End_Date - Start_Date = ????
Ravi Bike Cleanup Night 08-Jan-2014 28-Jan-2014
Vijay Car Cleanup Day 02-Feb-2014 28-Feb-2014
Vijay Bike Cleanup Night 01-Mar-2014 10-Mar-2014
Kumar Car Cleanup Day 08-Jan-2014 28-Jan-2014
Kumar Bike Cleanup Night 02-Feb-2014 28-Feb-2014
No.of_Days_Worked = No.of Days the person has worked in that particular workshop
No.of_Days_Total = No.of Days the person has worked in all the workshops
Please, help in finding the total number of days the person has worked in all the workshops by using any functions...
Thanks in advance
Bookmarks