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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. mrteacher

    Timesheet w/ Multiple Shift PayRate & OT Question

    Hey Skip - Sorry I had not given you any stars before now... forgot totally about that. TOO much multi-tasking. :( Steve
  2. mrteacher

    Timesheet w/ Multiple Shift PayRate & OT Question

    Thanks SKIP!!! I am going to have to "think" and review what you have written here!! I think once I "see" in a step process this working I will be able to get the last part -- at least I hope so. The worst part of this whole thing is that yrs ago I was much better at Excel -- when you are not...
  3. mrteacher

    Timesheet w/ Multiple Shift PayRate & OT Question

    Hi Skip - I already have for the first three columns: Total Hrs = IF(COUNT(B6:C6)=2,MOD(C6-B6,1)*24,0) Reg Hours = IF((D6=0)*AND(E5=40),0,IF((E5+D6)>40.01,40,E5+D6)) Total Reg Hrs = IF(MAX(E5:E11)>40.01,40,MAX(E5:E11)) OT Hours = IF((E6=40)*AND(D6<>0),(E5+D6)-40,0) What I am looking for now...
  4. mrteacher

    Timesheet w/ Multiple Shift PayRate &amp; OT Question

    Hi Skip, OK - if the IN/OUT must have DATE value in there would I be right believe that a complicated "IF" statement will work to give me the necessary results in the cells to the right? I am not even sure of the proper place to start a formula for this... In researching this on the NET - I...
  5. mrteacher

    Timesheet w/ Multiple Shift PayRate &amp; OT Question

    Hi Skip - It may appear that I do not have IN and OUT as separate cells but they are. So for that, I do understand the time/date thing. I was not sure "if" I needed to have the full month,day,year,time inserted. I was thinking that if you have 5P and ending is 5A then it obviously has to be...
  6. mrteacher

    Timesheet w/ Multiple Shift PayRate &amp; OT Question

    Hi Zack; I realize you mean well - however, I have looked through all the "templates" and none of them really seem to match the complicated nature of this scenario. With not only a broad spectrum of differing shift and shift rates with the shifts this is more complicated than any template. Steve
  7. mrteacher

    Timesheet w/ Multiple Shift PayRate &amp; OT Question

    Hi Skip... I thought I was being very concise with what I am TRYING to accomplish yet. Over in the Reg Hrs OT Hrs 1st Shift 2nd Shift 3rd Shift 1st Shift 2nd Shift 3rd Shift Columns I need to have those fields populate based on the information from "In" and "Out" and...
  8. mrteacher

    Timesheet w/ Multiple Shift PayRate &amp; OT Question

    A few more things for your info... You can go to http://www.excelforum.com/showthread.php?p=1826279#post1826279 to see a thread on this. The attachment listed as Timesheet Trial912a.zip posted on 9/14/2007 is the lasted I have for this file. Many thanks a Lost Novice... Steve
  9. mrteacher

    Timesheet w/ Multiple Shift PayRate &amp; 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...
  10. mrteacher

    Payroll - Multiple Shift and Overtime Question

    I really appreciate all the input -- however after I started to get into this more the "boss" decided that the "objective" was not explained clear enough to us... Here is the what we NOW have to work with and NONE of this is coming from the a computer input system -- like a scan card on the mfr...
  11. 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...
  12. mrteacher

    Options Security How to Restrict Changes

    Since there are ways to get yahoo messenger to operate through the browser - I need a way to stop that web page from coming up at all -- since I am not finding a way to lock out RESTRICT SITE the site(s) altogether for him.
  13. 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...
  14. 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...
  15. 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
  16. mrteacher

    Convert Outlook Express to Outlook 2003

    Thanks - now the real question is - where was my head when I did the search - another set of eyes - thanks guys!!!
  17. 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...
  18. mrteacher

    Query from 2nd table multiple

    Thank you to both of you for this input - I will try each one and see which offers the best simplicity for my wife. Since I need to make it easy for her - I will try both. It has been years since I have done any programming - therefore things like SQL and VB are not things I have the...
  19. mrteacher

    How do I backup/copy all word settings?

    Be sure to check your SAVE SETTINGS in OPTIONS this will help you to know "where" some of your files are being saved - unless you have forced a document to be saved some other place - for example - a template on a server. SD
  20. mrteacher

    Data Sharing

    Are you able to use PASTE LINK from the source data?

Part and Inventory Search

Back
Top