Re: Excel CORRECTION (1457175) | |||
Home > SubChat | |||
[ Read Responses | Post a New Response | Return to the Index ] |
|
Re: Excel CORRECTION |
|
Posted by BusRider on Wed Dec 6 10:10:20 2017, in response to Re: Excel, posted by BusRider on Wed Dec 6 10:08:10 2017. Thank you Bill and AIM. What I am trying to solve its pretty detailed.Here's Part 1 of 3: In cell B3, I have 13:50 In cell B5, I have 21:45 In cell C5 I have SUM(B5-B3) to equal 7:55 as such. But, in cells C7/C8 to determine Straight-time and Overtime AND to convert it to read 8 (C7) and "blank" (C8) being there is no Overtime. Because, I have not figured out a way for C7 to always display 8 based off of the formula in C5, I just entered 8 in that cell particularly. So in cell C8, I have this formula: "=IF(OR(C5<"8:00",C5>"8:00"),MROUND(C5-"8:00","0:15")*24,0)" Based on this formula, the logical test says its True, but cell C8 reads #NUM!, but when I switch the numbers so it has Overtime, as an example 14:20 start and 23:05 end, C8 reads correctly as 0.75. I played around with the formula as well, also using/including the AND function. Also, in addition, to convert C5 from reading 0.00 to a blank cell, I followed instructions using Conditional Formatting but it did nothing on my end. If any of you, can assist I would greatly appreciate it. |