|Re: Excel CORRECTION (1457175)|
|Home > SubChat|
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:
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.