Hi,
I have 2 columns which provide details on how much time was spent in completing a particular activity:
First column: start time (sample data - 10/28/2010 20:29)
Second column: End time (sample data - 11/1/2010 13:23)
I want a formula which will calculate the time taken to complete the activity based on the conditions below:
1] team works between 7:00 am to 5:00 pm and any requests which comes after 5:00 pm will be handled the next day, so in the above example since the above item came at 20:29 it would be handled the next day after 7:00 am and ideally the time taken to complete the activity would be 6 hrs 23 mins.
2] team works monday thru friday and any requests which comes on friday evening after 5 will be considered for monday morning.
This is a huge file and appreciate help in this regard.
I have 2 columns which provide details on how much time was spent in completing a particular activity:
First column: start time (sample data - 10/28/2010 20:29)
Second column: End time (sample data - 11/1/2010 13:23)
I want a formula which will calculate the time taken to complete the activity based on the conditions below:
1] team works between 7:00 am to 5:00 pm and any requests which comes after 5:00 pm will be handled the next day, so in the above example since the above item came at 20:29 it would be handled the next day after 7:00 am and ideally the time taken to complete the activity would be 6 hrs 23 mins.
2] team works monday thru friday and any requests which comes on friday evening after 5 will be considered for monday morning.
This is a huge file and appreciate help in this regard.
