Re: Excel CORRECTION (1457281) | |||
Home > SubChat | |||
[ Read Responses | Post a New Response | Return to the Index ] |
|
Re: Excel CORRECTION |
|
Posted by BusRider on Wed Dec 6 21:02:11 2017, in response to Re: Excel CORRECTION, posted by Bill West on Wed Dec 6 17:04:04 2017. Hey, Thank you for the explanation, I am definitely going to try it in a new spreadsheet. But I figured it out, the OR function was incorrect, I switched it to the AND function swapped the logical tests and it worked perfect and continues to do as so thus far using different times.To piggy back on what your saying your response. Part 3 of what I'm trying to figure out is, writing an IF statement (I assume) to convert into 8 hours. For Example: Say in cell C7 its 8.25 in cell C8 its 0.5 But the actual answer is ST 8 and OT is 0.75. I can do it manually in different cells using basic math and converting. |