I have a column I need to have a running total in, I then need a formula to say, if the figure in this cell is greater than 8 the balance over 8 must go into another cell. I'm thinking of the IF formula but I don't know how to say put the figure in this cell or put the balance in another cell. Trying to show that anything up to 8 hours is normal time, anything over 8 is over time and what the over time figure is..... Any ideas? Please help!!! :)
