Recent content by mrteacher

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

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...

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...

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...

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...

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

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...

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

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...

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...

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...

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.

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...

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...

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