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 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...
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
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...
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...
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?
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...
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...
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...
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...
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...
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
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...
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...
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...
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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.