|Re: Excel (1457174)|
|Home > SubChat|
Posted by BusRider on Wed Dec 6 10:08:10 2017, in response to Re: Excel, posted by Bill West on Wed Dec 6 03:35:16 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.
If any of you, can assist I would greatly appreciate it.