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