Subtracting lunch breaks from different shift times
I am trying to calculate the time spent by operators on the shop floor
actually working on a product. I have the start times and end times but
these times also include lunch breaks. Is there anyway in Excel I can
actually subtract the time of the lunch break.
For example if the operator works from 11:30 am to 1:30 pm I would like
to subtract 30 min from it (12:00-12:30). If the operator works from
11:00 to 12:15 and then 12:30 to 2:00 pm I would like to subtract 15
min from it (12:00-12:15) and add the remaining time (12:30 -2:00). I
have 1000 rows and doing this manually would take a lot of...OE removes access to certain types of files on e-mails
Grateful for anyone to tell me how I can set Outlook to
NOT automatically remove certain types of files eg PDF,
HTML, DAT files etc.
Are they removing them or blocking them?
See http://www.slipstick.com/outlook/esecup/getexe.htm for ways to get
the attachments off.
For more information on the security features, see http://www.slipstick.com/outlook/esecup.htm
If you use OE, hit forward on a message or disable it in tools | options
On 25 Apr 2004 02:07, "Sam" <firstname.lastname@example.org> wrote:
>Grateful for anyone to tell me how I can set Outlook ...How to open files type .sxw
I can't open open office files from friends with the .sxw file type. I have
Windows 98se and office 97. Is there a stand alone free program that I can
down load to open such files.
I would guess you'd have to download Open Office.
"Ernest" <Ernest@discussions.microsoft.com> wrote in message =
> I can't open open office files from friends with the .sxw file type. I =
> Windows 98se and office 97. Is there a stand alone free program that I =
> down load to open such files.
In addit...Make a formula
Is it possible with Excel 2000 to automatically
make a list of all the formulas you are using in
your spreadsheet to print them.
Steven E.'s Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1512
View this thread: http://www.excelforum.com/showthread.php?threadid=26758
This subroutine makes a new sheet (Formulas in Sheen N) in which all
formulas are listed together with cell reference and value. Not mine-own but
I have lost the reference to the author but I thank h...Invalid Value types in Lookup field
I am new at Access and don't really know what I am doing. I created two
tables... 1. contact information 2. subcontractors used at job sites. I
created a lookup field for the subcontractors so when I create reports or
queries I can connect the subcontractors with their contact information. I
set the field to text, but everytime I try to put the cursor in the field it
comes up with an error message saying that the value isn't valid for the
field. How do I get it to stop doing this?
Your first problem was defining a "lookup field" -- I'm sure Microsoft was
tryi...Dynamics GP 9.0
When you install Dynamics GP 9.0 from the CD, in the Insallation Type window
you will see Server Option or Client Option.
The first option should technically say "Server & Client", not just Server.
Needless to say, when you Install Server, it installs Client as well.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft...vlookup type problem
I've a problem that a standard vlookup will not solve for me as it
always returns the first value it finds.
My problem can be illustrated by the fictional example below.
I have 2 tabs in a workbook; tab1 and tab2.
Tab1 has one populated column and the heading of it is name.
Tab2 has two populated columns and the headings are name and age.
Tab1 contains the following data.
Tab2 contains the following data.
The two Lukes are different people.
If I use a formula like below on Tab1, Luke will have the age 26 twice
and th...Strange error message when loading a collection with an item of user defined type
I want to store an unknown number of records, read from a txt data,
into a Collection. Each record is made of 26 strings, so I defined a
user-defined type Record:
Const NLines As Long = 26
Lines(NLines) As String
Dim MyRecord As Record
I also defined a Collection object to store all the record:
Dim List As Collection
Set List = New Collection
However, when I read a record and then try to load it into List:
I get this incomprehensible (for me) error message:
"Only public user defined types defined in publ...Automatic printing with or without a workflow process can it be done?
I don't know if i'm asking this in the right place but here goes;
I'm an admin seting up Microsoft CRM 1.2 and I want to know if there
is any way that i print out some basic details on to a label printer
when I create a case, heres the senerio
we are an IT company and when small jobs come into the repair shop i
want to create the case in in Microsoft CRM 1.2 which will then in
turn automaticly print out the case no. along with customer name and
contact phone number in plain text to a printer, this label can then
be stuck to the PC being repaired also i want the work flo...Automatic Underlining of Outgoing Emails
From the beginning, all my outgoing emails are automatically
being underlined. I turn the underlining off, and the
text appears to be not underlined, but when I send a test
document to myself, the document I get back is all
underlined text. I'm using Word 2003 as my e-mail editor.
In Word 2003 options-general-email options-personal..... i turned of
all underlining. Now the text still appears to be not underlined, but
the outgoing message is all underlind text.
When i turn off Word 2003 as my e-mail editor, the problem is solved
Please help me get rid of this annoying and unsightly ...how to get position of cursor in EDIT control??
How does one get the position of the cursor in an edit control? I am not
talking about the mouse cursor and that is what GetCaretPos() and
GetCursorPos() do. I am talking about the blinking vertical line. There
doesn't seem to be any way to get it?? I want to be able to get it in client
or screen coordinates. Thanks!
"Nobody" <email@example.com> wrote in message
> How does one get the position of the cursor in an edit control? I am not
> talking about the mouse cursor and that is what GetCaretPos() and
> GetCursorPos() do. I am...Downloads to Quicken automatically going to Money
I have Money and Quicken loaded on my PC. When I attempt
to download to Quicken, it is automatically loaded to
Money. How can I stop this?
Install Quicken second. The last one installed takes control of the QIF
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or email firstname.lastname@example.org especially if it's a UK specific wish.
I do not respond to any unsolicited email regardin...automatically create chart upon selecting
I have a spreadsheet containing about 50 different
financial ratios for 2002 thru the current month. I want
to be able to click on the name of the ratio and have a
chart automatically generate using all historical data
thru the current month, thus including each month as it
is added. Does anyone have any suggestions?
On Wed, 29 Oct 2003 07:43:30 -0800, Jason <email@example.com> wrot=
> I have a spreadsheet containing about 50 different
> financial ratios for 2002 thru the current month. I want
> to be able to click on the name of the ratio and have a
> char...Automatic printing
Is it possible to use a macro to print out a worksheet when a cell in
that worksheet contains a specified number? I have a worsheet that
pulls info from another program and I want it to print when cell d6 is
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Try the following:
Right click on the worksheet TAB>View Code
then enter the following code
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("d6"...Automatically add 1 until a number is found
I am developing a spreadsheet which basically grosses-up a paymen
which i have to make to an employee.
What I'd like to do is take a cell and add 1 automatically until th
number equals a specific equation. Is this feasible?
Message posted from http://www.ExcelForum.com
Have a look at Tools / Goal Seek. It might be what you are looking for.
"jkyndt >" <<firstname.lastname@example.org> wrote in message
> I am developing a spreadsheet which basically grosses-u...With start-up my printer automatically re-prints all work. Why?
I have a new OKI B63000 printer and every morning with Windows Start-Up, my
printer automatically re-prints all my day's work, needlessly wasting a lot
of paper and toner. I imagine there is a command somewhere for this. How can
I stop it?
Might look in scheduled tasks.
How To Schedule Tasks in Windows XP
Mary Sauer MSFT MVP
"Andry C" <Andry C@discussions.microsoft.com> wrote in message
news:D092C731-CE6D-403A-B7B3-6C3C57C2F92D@microsoft....Print Template automatically Filled with data in another worksheet
I have a Form in Sheet2 like:
Emp #: B5
and list of Employees A2:D123 (more than 100 employees) with above details
I want to Print Sheet2 for each of the employee with its details. I know It
easily done with Word Mail Merge option but the form created in Excel could
not be easily developed in MS Word.
Is there any solution.
You would need to use a macro:
Dim myCell As Range
For Each myCell In Worksheets("Sheet1").Range("A2:A123")
With Worksheets("Sheet2...macro to run automatically when a field is updated
I have two form fields on an employee appraisal form. One calculates a grand
average score from four different scoring areas on the form. The second field
evaluates this score (using a macro) to determine the increase percentage
based on the grand score. This macro is assigned to the field to run on
My problem is that if an evaluator goes back through the form and changes a
score, they must click in this percentage field to get it to update to the
My question is: how could I make this field update automatically anytime a
change is made anywhere on t...Updating form automatically
I have two columns in a table which are sources of dropdown boxes in a form.
In the form, when the value in one dropdown box is changed by the user, how
can I automatically update second dropdown box according to the data in the
table. For example in case of "copyone" as value in first dropdown box,
second drop down box has "paperone". When "copyone" is changed by "copytwo",
"paperone" should be changed with "papertwo". So far I am unable to do this
successfully either with SQL or VB. Any ideas will be highly a...Error 2035 X500 Address Type Missing
Pure Ex2003 SP1 site (after 5.5 migration several months ago). Other 4 sites
in Exchange Org are pure 5.5. Everything seems to be running ok, no ADC
errors, no RUS errors, no SRS errors...
Just got error 2035 ExchangeSA after changing (via ADUC) new user's
misspelled last name on all his e-mail address types. "The e-mail address
description object in the Microsoft Exchange directory for the 'X500' address
type on 'i386' machines is missing." (Did not get 2027 or 2037 errors about
any missing .dll)
Following KB 326962 -- Using Adsiedit to check, x.500 is n...Keyboard shortcut for cursor
What keyboard shortcut can I use to put the cursor in a
cell that is highlighted?
I am tired of double clicking a cell to get the cursor to
"Baylis" <email@example.com> wrote in message
> What keyboard shortcut can I use to put the cursor in a
> cell that is highlighted?
> I am tired of double clicking a cell to get the cursor to
need to superimpose "draft" across excel pages
Here's a copy of a reply to this subject from Ron de Bruin,
You can use Word Art, remove the lines, color with 25% gray, click
semi-transparent (or in latest version set the transparency to your
Rotate to desired angle. On the screen, when you type over the mark, it
looks a bit fuzzy but prints out wonderfully
If you have many to do try this:
Here is some code from L. Howard Kittle.
In this Zip file you can find 4 example workbooks with code to insert
wat...I want cursor to go to "To" box when beginning a message.
When I start a new email, the cursor is automatically in the area where you
type the message.
"charqa" wrote in message
> When I start a new email, the cursor is automatically in the area
> where you
> type the message.
Goes to the "To" field for me in Outlook 2002 using Outlook's own
embedded e-mail editor. Don't know which version you are using or if
you're using the embedded editor or Word for new mails. You could try
starting Outlook in its safe mode ("outlook.exe /safe&quo...is there a way to automatically delete NDRs in the Queue
How can I automatically delete NDR messags in the queue?
"North Coast Sea Foods" <firstname.lastname@example.org> wrote in
> How can I automatically delete NDR messags in the queue?
I don't think you can delete them automatically, but you can stop them
being generated in the first place. In ESM, go to Global
Settings/Internet Message Formats/Default/Properties/Advanced . The
ones that are already queued will disappear in a few days' time.
Outlook Web ...How to not show particular Activity Types
Does anyone have a suggestion to hide particular activity types (such as Fax,
Service Request, Campaign Response) when a user clicks Add Activity? We have
a call center that will only be scheduling tasks for other users, so we want
to hide all of the unused items.
We are in 3.0. Thanks for any suggestions