Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
figure out why this formula isn't calculating correctly
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weekday formula calculating to end of month | Excel Worksheet Functions | |||
CALCULATING A FORMULA TO USE A SPECIFIC CELL'S VALUES | Excel Worksheet Functions | |||
formula returns (correctly) a negative value | Excel Discussion (Misc queries) | |||
Formula for calculating age | Excel Discussion (Misc queries) | |||
How do figure excel formula out? | Excel Discussion (Misc queries) |