Home · Maps · About
Home > SubChat
 

[ Read Responses | Post a New Response | Return to the Index ]
[ First in Thread | Next in Thread ]

 

view flat

Re: Excel

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:

"=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.

If any of you, can assist I would greatly appreciate it.

Responses

Post a New Response

Your Handle:

Your Password:

E-Mail Address:

Subject:

Message:



Before posting.. think twice!


[ Return to the Message Index ]