How to take out efficiency of Billing Dept.

[rush2rajen]

Hi Excel Gurus,

I had been asked to take out efficiency of a person who sits and bills.
The time taken by them to bill a single letter and total time taken and avg time taken.

Also need a Dashboard of the same, but I am unable to take out the same due to format given in TIME format. There are some 10000 bills for which I need to take out the same on a daily basis.

I had given the requirement in the attached file.
Also need some formula except for VBA or macros to change time into some other format like numbers so that it can easily be subtracted.

Please help.

Thanks
Raj

 

[Somendra Misra]

Hi Raj,

Please see the attached file. Sheet5 & Sheet1 Yellow cells. I am not sure for column G & H on your Sheet5 for your expected output. Kindly inform the same.

Regards,

 

[rush2rajen]

Hi Misraji,

Thanks for the same. Others I will manage.
One more query raised request you to clear the same.
File attached

Thanks
Raj

 

[Somendra Misra]

See your file.

You can separate name with numbers with Text to column by specifying "(" without quotes in Others deliminator as done on sheet2.

Regards,

 

[rush2rajen]

Misraji,

Bahut Bahut Dhanyawad. Learning lot of new things from Excel Ninja's. Thanks a Lot.

Thanks
Raj

 

[Somendra Misra]

Welcome back Raj!!!

Regards,