Accounting for day rates

[Biggsy66]

Hi guys,

I have a billing sheet, looks roughly like the one below. At the bottom of the cost column is a total that tells me how much to bill a client for a particular job, based on the hours worked and the cost of those hours. However, if any individual does more than 80 units of work on a given day, the maximum we can charge is for 80 units. Is there a formulae i can use to calculate from this list the actual amount i should bill? In the case below the bill would be for 72y and 80x even though there are 86x units accrued by Joe. If it cannot be done as a formulae then a macro would be appreciated also

Name	Date	Units	Unit Cost
Joe Bloggs	25/6/16	25	x
Joanne Smith	25/6/16	72	y
Joe Bloggs	25/6/16	61	x

<tbody>
</tbody>

 

[Jonmo1]

Try

=MIN(80,C2)*D2

C2 = Units
D2 = Unit Cost