Conditional formula in excel?

[willhub]

Hi,

Trying to do a calculation that basically shows how much over 480 seconds the value of a time brake is, I then will add these up in total over a team, now adding them up is all messed up when you're under the 480 seconds, so I simply want it to show the total over when the figure is over 480 seconds.

Hope that makes sense

Thanks.

 

[willhub]

I store it as seconds, there is another cell that shows it in minutes, but I use the seconds value formatted in seconds for the actual calculation.

 

[willhub]

To be fair I'm just doing it as instructed, the stats are out there already I'm just been creative and improvising the way I send the stats. Every little helps out bonus and I want money.