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:


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.


Post a New Response

Your Handle:

Your Password:

E-Mail Address:



Before posting.. think twice!

[ Return to the Message Index ]