<That 10 hours is calculated as follows:

Unfortunately the 10 is not used in your formula.
Show us how the 2, 8 and 96 are calculated.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave F" wrote in message ...
| Here's the formula:
|
| =IF(OR(ISTEXT(R15),ISTEXT(R16)),0+Q19,(R16+R15)+Q1 9)
|
| R15 = 2, R16 = 8, Q19 = 96
|
| The calculation should be 2 + 8 + 96 = 106, but it's giving me 107.
|
| Here's where I think the error is occurring: the 2 and the 8 are calculated
| based off the amount of time between two points during the day; 8 hours of
| regular and 2 hours of overtime, or 10 hours of labor. That 10 hours is
| calculated as follows:
|
| =IF(ISBLANK(R13),"",(R13-R12)*24) where R13 = 6:30PM and R12 = 8:30 AM
|
| So, if we go back to the first formula, this is where I get lost.
| Obviously, somewhere, somehow, Excel is rounding but there's nothing to
| round: 8:30AM - 6:30PM is 10 hours, even.
|
| Ideas?
|
| --
| Brevity is the soul of wit.