Search results for query: *

Thanks for attempting to help, but I have it figured out... ="0"&LEFT("0"&TEXT(A1,0),8)&MID("0"&A1,11,2)&MID("0"&A1,9,2)&RIGHT("0"&TEXT(A1,0),2)&"00

I've been struggling with this for a while and desperately need someone's help. I need a macro that will take a 13 digit number, add a zero at the front, change the place of the 9th and 10th digit and then add two more zeros at the end. For instance: Take 08347004003486 in Column A and change...

I've been struggling with this for a while and desperately need someone's help. I need a macro that will take a 13 digit number, add a zero at the front, change the place of the 9th and 10th digit and then add two more zeros at the end. For instance: Take 08347004003486 in Column A and change...

I want to export a query from Access to Excel and then analyze the data. What I'm pulling into Excel is data with 31 columns. (30 are audit questions and the last is the name of the person being audited.) Row 1 is a header row, showing each question's description. (i.e. Greeting, time...

That worked! Thanks!

I'm struggling with an Excel spreadsheet that contains 91 rows. What I’m trying to do is: Sum all rows in Column G when Column B=.0001 and Column E=1 within the same row. In other words, only add cells in Column G if, within that same row, Column B=.0001 and E-1. Make sense? Can anyone...

SELECT Tbl_Main.ContactID, Tbl_Main.[Consultant Name], Tbl_Main.[Company Name], Tbl_Main.[Date of Service], Tbl_Main.[Date Audit Completed], Tbl_Main.Auditor, Tbl_Main.CFMI1, Tbl_Main.CFMI2, Tbl_Main.CFMI3, Tbl_Main.CFMI4, Tbl_Main.CFMI5, Tbl_Main.CFMI6, Tbl_Main.CFMI7, Tbl_Main.CFMI8 FROM...

Yes, that's what I need. Can you walk me through setting up the summary and the check box command?

Yes, there is a table (tbl_score) that the question scoring combo boxes pull from. We want it scored per audit. We have auditors that review others' work and answer 8 questions (MI1, MI2, MI3, etc.) Based on the work, the questions are either "1" (Yes) if that indicator was met, "0" (No) if...

I have a form that lists 8 audit questions that are scored 1, 0, -1 (Yes, No, N/A) using combo boxes. What I need is a query that will count the "1" scores and mark a check box as true if the result is 3 or greater - excluding the No's and N/A's. Can anyone assist???

Got it - It worked! Thanks so much!!!

Yes. I've tried formatting both as percentages, both as numbers with decimal places, nothing works. That's why I'm struggling so much. I can't figure out what I'm doing wrong.

I tried that, but obviously I'm doing something wrong. Here's my scoring scale: 100.00% 5 99.80% 5 99.79% 4 99.50% 4 99.49% 3 99.00% 3 98.99% 2 98.50% 2 98.49% 1 0.00% 1 Any percentage I'm putting in is returning a "#NA" with the exception of 100%, which is returning a "1". I've tried...

I'm creating an employee performance database and need to know how to assign a score dependent on a percentage. For instance, if an employee achieves between 99.8% and 100%, the score should be "5". If the employee achieves between 99.5% and 99.79%, the score should be "4" - and so forth. The...

For the last couple of weeks, IE stalls everytime I go to a new web page. The page will load, but I have to wait approximately 20-30 seconds before I can click any links. This is getting extremely frustrating, since I'm working on a LAN and am use to almost instant page loading. Anyone have...

I'm needing to design a report that will score employees on their performance. I've tried several different possibilities, but cannot get any of them to work. I'll explain what I'm trying to do below: There will be a total of 14 possible measures listed in 14 columns across the spreadsheet...

Is there any way to "catch" the hours in a cell and convert them to text in another cell. For instance - I have a cell with "172:10:20". The cell has been formatted to hhh:mm:ss, but still shows as "1/7/1900 4:10:20 AM" in the formula bar. How can I get an empty...

Two questions... 1.) What formula would I use if I'm given - start time of 9:30, finish time of 10:00 and 500 pieces printed - if I need to figure the time taken to print each piece (# of pieces/hour)? 2.) Is there a way to setup time cells so that I do not have to type the colon everytime...

Let me better clarify... Our main responsibility is to monitor scoring of contractual performance guarantees. Say, for instance, we are supposed to answer 95% of all calls made to our call center within 30 seconds. Based on our monthly scores for the last two years, we would like to set...

I have been asked to determine the upper and lower control limits for monthly data in a simple spreadsheet. The data consists of just one percentage amount per month for two years. Is there an easy way to do this?