Search results

Yes data can be sorted as below, what I use, don't know what impact will it make on calculation by sorting data with finish time also as I have never tried or done it. Tech Name ................... Start Time Note :For your reference, each for each tech has to be treated separately (mutually...

Hi Narayan, The situation which you have mention will never arise, As of now the multi-tasking can be performed maximum of 2 task. But it would be great if a dependent cell is there Multi-Tasking can be defined as 2 or 3 because it will never go beyond 3. Enclosed is the file for your...

I am ready to wait for couple of minutes while calculation is updated. So overlapping is calculated on 1 tech at time for each date/day separately, overlapping time between different techs are not calculated. My intention is to get multi-tasking of single tech. For example - if you will apply...

Thanks for your response Peter, I am looking for the initial calculation (Red one) which you have shared. Thanks a a ton for helping while you are occupied, this is great help. I am enclosing the larger data file where I am not able to apply the calculation you have shared in Red, as that is...

Thanks Peter for your help, It seems to be working, but how can I extend this to work at 10000+ record for multiple tech's, as I am trying to extend the ranges but it is not letting me do that. So maximum task one goes back is, First task of the each day for individual tech. So when the date...

Dear Hui, Thanks for your prompt revert, this is sample data there can be 50 tech and data can of 10000 row, So doing this for small piece of data is easier manually but it becomes next to impossible when number of record increase. It might be that one tech is handling 2 or 3 task at same...

Hi, I am looking to calculate the overlapping time for each task instance basis the start and end time for each tech. Enclosed is the file with data and the manual solution which i have prepared to get the relevant reference to the formula or a VBA code which can validated with column "G" &...

Have you tried using Pivot table or "Countif" function to get the unique records.