I need to calculate the cost per hour for an consultant.
The cost per hour will be: (Total Cost / Total worked hours)
But I also need the cost per client A:
The cost for cliente A: (Total Cost / Total worked hours) * Total worked hours for client A
I have in total 10 clients, but when I try to calculate for 1 client the cost per client is incorrect.
I will aprecciate if someone can help me.