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 CORRECTION

Posted by BusRider on Wed Dec 6 21:02:11 2017, in response to Re: Excel CORRECTION, posted by Bill West on Wed Dec 6 17:04:04 2017.

Hey, Thank you for the explanation, I am definitely going to try it in a new spreadsheet. But I figured it out, the OR function was incorrect, I switched it to the AND function swapped the logical tests and it worked perfect and continues to do as so thus far using different times.

To piggy back on what your saying your response. Part 3 of what I'm trying to figure out is, writing an IF statement (I assume) to convert into 8 hours. For Example:

Say in cell C7 its 8.25
in cell C8 its 0.5

But the actual answer is ST 8 and OT is 0.75. I can do it manually in different cells using basic math and converting.

Responses

Post a New Response

Your Handle:

Your Password:

E-Mail Address:

Subject:

Message:



Before posting.. think twice!


[ Return to the Message Index ]