From: Pete_UK on 17 Feb 2010 12:47 Suppose your 15 is in A1. This will give you 3.5 in one column: =MAX(0,MIN(11,A1)-7.5) and this will give you 4 in another column: =MAX(0,A1-11) and will cope with other values as expected. Hope this helps. Pete On Feb 17, 5:36 pm, Teri wrote:> Hi there.  I'm hoping someone can help me.  I'm pulling my hair out trying to > figure out how I can take a certain number of hours (for OT banking purposes) > and calculating anything over 7.5 hours, up to 11 hours in one column - and > anything over 11 hours in a separate column. > > For example:  An employee worked 15 hours in a day.  In the first column the > formula would provide the number 3.5 (as 7.5 plus 3.5 is 11 hours for the > day) and the second column would provide the number 4 (as this is the number > of hours over the 11 hours). > > Any help that anyone could provide would be GREATLY appreciated! > > Thanks so much!! > > Teri  |  Pages: 1 Prev: Multiple name appearancesNext: Conditional Formatting for entire row