Excel 2007 : I want to change a cell depending on the % of a total figure.

Hi,

Another query sorry.

I've been given a budget say £100 p/d

I've broke this down into working hours and so a daily rate would be - £16.45 this is 13% of the total buget per hour.

So now i have 2 columns an hourly max and the daily %.

My question is... how can i alter the hourly max by changing the daily % but without the daily % column going over 100?!

All help would be massively appreciated, thanks in advance, sorry if it's not worded well!

Lloyd

Can you post an example worksheet please?
Your numbers seem to be confused in that 1.45 is less than 13% of 100