rush2rajen
Member
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
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