Capture Time

[MohitMathur1234]

Hi,

I need help to find out time.
I have a file which is modified by multiple persons.
In first case, Urvashi yadav 2 started working and she spent 00:31 sec and again she worked the same and spent time 1:13 min. and so on
I want to capture time on the next sheet1 where on file DeepakGoyal1088011.xml has urvashi so the total time will capture there means total time spent by urvashi should be there. and if like Mohit saraf has not worked on the DeepakGoyal1088011.xml so time should be 0 there.

Plz find attached file.

Thanks..

 

[wudixin96]

You should fill all blank cell in Col D

 

[MohitMathur1234]

Thanks alot .. I was doing this same but not filling Col D. thank you to tell me my mistake..

 

[Somendra Misra]

HI Mohit,

Based on above suggestion please find the attached file, with Pivot doing the same for you on Pivot Sheet.

Regards,

 

[MohitMathur1234]

Hi,
Thanks.. Also usefull......