Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mrteacher
  • Content: Threads
  • Order by date
  1. mrteacher

    Timesheet w/ Multiple Shift PayRate & OT Question

    I am putting together a workbook where IN / OUT is entered and it calculates Total Hrs and OT Hrs once 40 Hrs has been reached in the week. Problem: 1) Each "shift" is at least 12 hrs long 2) Some "shifts" span two or more manufacturing shifts 3) Once Hrs is greater than 40 in the week the...
  2. mrteacher

    Payroll - Multiple Shift and Overtime Question

    I have a good scenario that I am not quite sure how to proceed with. Wondering if someone has idea or thoughts on how to make this work right. It is amazing how on paper you can do some things fast -- but trying to get the formula/idea right in workbook is harder!! employee Shift 1...
  3. mrteacher

    Options Security How to Restrict Changes

    I want to be sure that the websites I put in for the likes of Yahoo Messenger and Windows Messenger my son cannot use. Problem the way I see it is that if I go to Tools/Options/Security and then Restricted Sites to put in the websites -- he will just delete them and then put them back in after...
  4. mrteacher

    Auto Complete in Excel 2003 or higher??

    I am trying to do an AUTO COMPLETE of sorts (like you might do in Word). Here is an example: A B C Joh123 John 123-45-6789 Sal234 Sally 234-56-7891 Bru567 Bruno 567-89-1234 In Col A you would type in the Letters and Numbers...
  5. mrteacher

    Outlook 2007 Trial Not available in PRO

    Anyone have an idea why when I install Office 2007 Trial that Outlook does not install? I am looking to upgrade from XP - BUT I do not want to buy Office Pro 2007 if I can not use Outlook 2007. -- Steve
  6. mrteacher

    Convert Outlook Express to Outlook 2003

    Here is a question that has two major parts to it per-say: 1) How to take ALL configurations from Outlook Express and have OUTLOOK setup everything? 2) How to IMPORT all e-mail addresses and e-mail into Outlook? WHY... My father is rather a WEAK COMPUTER NOVICE living now in Florida (I am in...
  7. mrteacher

    Query from 2nd table multiple

    I am the distint "pleasure" of helping my wife with a task that is way beyond me... :( There are 2 separate files, from EMP_DB.XLS I need to pull the data in two columns (REF # and SPF) to two columns in PAY_DB.XLS. In both tables I have LNAME, FNAME and SHIFT that match. Therefore I will...
  8. mrteacher

    Payroll Question

    What is the best way to combine either on one of the payroll sheets or a new one - total of 3 sheets (workbooks) when I have very little for commonality of fields using Excel 2003?
  9. mrteacher

    Combine Payroll Worksheet Data???

    I have 2 (two) different payroll sheets with the ONLY potential matching data being the employee name. I can get this to equal each other on the sheets - HOWEVER - Look at my examples and see if there is an easier way than so many checks and attempting to populate: Example with title and...
  10. mrteacher

    Symantec Enterprise Removal

    Anyone here know how to blow a copy of Enterprise off a laptop that I was given? It asks my for the Admin Code. I do not have that. The company is no longer in business - so now I have no one to go to. Sort of stuck - since it is taking up hard drive space and will not update - automatically...
  11. mrteacher

    WIN 2000 Pro SP4 - ITunes Dr. Watson Error 87

    This is my girlfriend's laptop and trying to help her - but am "fuzzy" on Win 2000 and Dr. Watson. Maybe someone can enlighten me with a solution to this problem: 1) I installed ITunes (for IPOD) on a laptop with Windows 2000 Pro on it. 2) After getting Dr. W and Error 87 - I looked through...
  12. mrteacher

    Defrag the C Drive Question

    Friend of mine is having problems with her C drive not defragging... It is a small drive - about 1 GB - her D drive is 40 GB (just for fyi here). I suggested that she remove all tmp files and then defrag the drive because it was running slow. She e-mailed me back with the following: --- BTW, I...
  13. mrteacher

    Dell Dimension 8250 Memory - Slow System

    I have Dell P4 2.4 Tried to put in another 512 of RAM - Newest Bios v4 not recognizing it. OS is XP Pro SP2. Just installed new 250GB HD and the OS and Win XP Office. System either on internet or off runs very slow... like watching paint dry and grass grow. Wait,,, wait,, wait. If I take out...
  14. mrteacher

    Why cannot come back from Hiberation or Standby

    Have Dell Latitude that when I put into hibernate or standby, the system will not allow it to come back - outside of powering down and doing a restart. Thank you Steve
  15. mrteacher

    XP Pro not bootable - Black Screen ctrl+alt+del ????

    This is something I just ran into on my Dell 2.4 Desktop. This past weekend I rebooted the PC after having it off during the week. It came up with the error in subject line. I put in the Win XP Pro CD to find way into PC. I can see the hard drive. I can not reload windows because Win XP is...
  16. mrteacher

    CDRW Not shutting Down when not in use

    My Parent's CDRW will not stop spinning or accessing (the light stays on even when there isn't any media in the drive). Why is this happening and what solution is there for this? If you need more information, please let me know. Win98 - I am now in the dark on and CDRW I am not sure of...
  17. mrteacher

    Contacts in "To:" list to add to address book

    I rec'd an e-mail in my Outlook and would like to add all the addresses that the e-mail was sent to besides me... How can I add all those contacts that are in the "To:" address field to my contact list? Is this a manual process? I cannot imagine that Microsoft would allow that to be...
  18. mrteacher

    Sent to many accounts, how to import all into Outlook Express

    I receive a few e-mails that have multiple people in the "To" field. How can I have all those addresses go into my Contacts Folder -- aside from doing all 50 or so manually? When I tried copying all and pasting, I loose the e-mail address -- because all that is copied is just the text...
  19. mrteacher

    Mid from cell - need help

    I thought I had the formula correct to pull the "state" part out of cell A1 but am coming up blank. Below is the example and the formula I modified from an April posting. Example: Two Rivers, WI 54241 cell C1 has...
  20. mrteacher

    Separate value from name in a cell

    In cell A1 is: 12.53LNAME I need to separate the 12.53 from LNAME. I tried =IF(ISNUMBER(FIND(".",A1)),LEFT(A1,FIND(".",A1)-2),"None") All I am getting is the word "None" which is the false part of IF statement. Can someone lend a hand? Thank in advance.

Part and Inventory Search

Back
Top