how do i find a true value between two different times e.g. 4:15
i would like to find the exact value between two different time in hours and
minutes e.g. 4:15 (4 hours 15 minutes) and not 4:42 (4.42 hours) for example.
Subtract them! An example: Enter 8:45 in A1 and 5:15 in A2. Enter the
formula =A1-A2 in A3 and, voila, the answer is 3:30. Excel will
automatically assign the time format to A3 if it has the General number
"Chris01623" <Chris01623@discussions.microsoft.com> wrote in message
|i would like to find the exact value between two different time in h...Getting URL Cache Information
I have to get the URL information for an image. I dont know how to get
it. Kindly help me.
Thanks a lot.
...How do I put information into a NEW journal table?
Having created a New table in Outlook 2003 Journal with different column
headings (to record family tree history), how can I put information into each
of the new headings, which do not appear on the Journal Entry form?
You'll need to create a custom fields for the new information.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWS...How do I insert a clip art picture into a text box in word 2003
Trying to insert a picture into a text box in Word 2003 with very little
success. Using Word as some students in the community do not have access to
Publisher. Trying to create 4 invitations to a page. Want to use a text box
to include text and graphics and then copy and paste four times. Help.
you'ld be better of posting to
rather than an excel newsgroup
personally, i would use a 2x2 (or 1x4) table in word for this rather than
"Lindas" <Lindas@discussions.microsoft.com> wrote in message
news:...outlook signature is greyed out
for some reason outlook signature is greyed out
it was working at one time and we created a new profile and then set up the
outlook client and at the point is when this happen. ive seen this before
but can not remember what i did to fix it.....
Hi - what version of Outlook, and are you using Word as email editor? Best
to post this (with more info) to microsoft.public.outlook, as it's not an
> for some reason outlook signature is greyed out
> it was working at one time and we created a new profile and then set
> up the outlook client and at the poi...Paste Linked Table
Is there any way to paste an already linked table as another linked table as
you can do manuualy but programatically?
>Is there any way to paste an already linked table as another linked table as
>you can do manuualy but programatically?
A linked table is just another TableDef object with
something in its Connect property. That means you can use
the DAO CreateTableDef method (see VBA Help) and copy the
properties of the existing linked TableDef. That's
essentially what Access does when you use Copy/Paste in the
OTOH...unhide data in pivot table
Operating System: Mac OS X 10.6 (Snow Leopard)
I saw that this has been raised before but did not see a solution posted. Has anyone found a workaround? The issue again, I have created a pivot table and in it I ahve e.g columns with data for different years. I want to hide the data on one year and select thehide functionin the fieldsettings and it does disappear neatly, however, when I want to turn this back on it is not possible. It does seem like the cmd button should do the trick when i click it witht he year marked in the fieldsettings, however, it has...How do I get a cell to remember the last entry and add to it?
I am using Excel 2000. I want my cell to remember the number in it and add
an additional number each time I need to retotal.
Sounds like you want that cell to be an accumlator cell.
Simple question with complex results.
You can have a cumulative total in a cell if you have a
separate source cell for adding a new total to the original.
Use at your own risk. I am Posting this just to show you how it can
be done, not as a good solution. You would be much better off to
have another column so you can keep track of past entries.
Goes like this: =IF(CELL("address")="$C$4&...getting message interface error and can't send or receive emails
If I try to move or delete an email I get a message - "The message interface
has returned an unknown error. If this problem persists restart outlook." I
have restarted outlook several times and also re-booted my PC several times.
Still to no avail I cannot send or receive emails now either.
While Outlook is closed, rename the Outcmd.dat and *.srs files, then open
Outlook again and see if this helped. If not, please post back.
Also, please post what version of Outlook you're using. If you have reached
the limit on your PST, that could cause the error as well.
Kathleen...Printing Pivot Table Pie Charts
I have 1400 names in a list each, person has their own data. I created a
pivot pie chart to display that data. Can anyone tell me how to print the
pivot table so I get a separate sheet for each name selected...without me
having to click on the dropdown list each time?
Also does anyone know how to hide a field, but have the data still be
displayed in the pie chart?
I have 2 lists with approximately 100 items/rows, with 5 pieces of data in
each row. Each list has a common element (account number). Many times the
account number shows on both lists, and I want to combine How do I combine
both lists to use as source data in a pivot table?
...Cant use word as e-mail editor
If I check Word as e-mail editor in Outlook options,
I get following message: "This form requires Word as your
e-mail editor, but Word is either busy or cannot be
found. The form will be opened in the Outlook editor
I de- and re-installed Office XP complete but issue is
If you open Word, normally, does it run?
>If I check Word as e-mail editor in Outlook options,
>I get following message: "This form requires Word as
>e-mail editor, but Word is either busy or cannot be
>found. The form will be open...how to get size of text in a Dialog?
MessageBoxes usually size themself according to the text displayed,
depending on fontsize and number of chars.
can anyone please explain (or point me to an URL where it is explained)
how they do it? To keep it simple, lets say we have just a CStatic and
a Text in it.
How do i get the "optimal" values for the region for MoveWindow() ?
".rhavin grobert" <email@example.com> wrote in message
> MessageBoxes usually size themself according to the text displayed,
> depending on fontsize and number of char...getting calendar event reminder for deleted event
I keep getting a reminder for an event that has been deleted from my
calendar in Outlook 2002. The event is past due but has been deleted
so I get an error message saying there has been an error dismissing the
How can I repair this? I've tried running Scanpst.exe but no joy.
> I keep getting a reminder for an event that has been deleted from my
> calendar in Outlook 2002. The event is past due but has been deleted
> so I get an error message saying there has been an error dismissing the
> How can I...Totals in pivot table
I have a sheet where I store some records in this - simplified -
Article | quantity
XYZ | 4
KLM | -2
XTR | 3
XYZ | -1
There is a minus sign when it's a shipping, otherwise it's a receiving.
The pivot table adds/subtracts quantities depending on the sign,
and shows for each Article, the quantity available in stock.
Once an article quantity become 0, I would like that row to disappear
from the pivot table,
I dont need a stock list with quantities: 0.
Is there a way to do this (not copying the pivot table and removing
manually the 0 rows...)
...Difference between an excel worksheet and XLXS file
I'm a beginner in the world of computer and ms office. On my computer I
using Office2007. In excel Icreate a file and saved it as .XLXS file. For the
correctons of this file I send to my friend,by using a flash disk. My friend
is using Office2003. My file is not oppen on my friend's computer.Why?
"Martin" <Martin@discussions.microsoft.com> wrote in message
> I'm a beginner in the world of computer and ms office. On my computer I
> using Office2007. In excel Icreate a file and saved it as .XLXS f...Getting Excel 2000 Options to be remembered
Two questions really:
1. How do I get options for a particular workbook to be saved? I am findng
that the option to have R1C1 Reference style to be ticked does not get saved
with the workbook but other options do.
2. How can I get options to be either global for all workbooks or for a
range of workbooks?
Unfortunately, R1C1 style is one of those options that is set by the first
workbook that is opened in a session. Calculation Mode is another.
You could set the R1C1 style in your Personal.xls which will open hidden with
each session of Excel, thus ensuring that th...Merging excel data into word #2
Ok, I have a feeling this process is quite simple, but I haven't bee
able to figure it out on my own, nor find anything in FAQ's.
I have created an excel spreadsheet containing the following:
students' last name, first name, ID number, advisor and counselo
(obvioulsy Im in education)
I would now like to create a phone call log for each student, but woul
like to import each students' info into this word document. So as
print the 100 or so pages, page one would have the first students info
page two would contain the second students info, and so on.
Any help is greatly appre...'Word is waiting for another application to complete an OLE action'
This happens when attempting to copy a visio file to
word, wheter link, embedded or picture.
Then is brings up Task Msnager.
What is is trying to tell me?
We have the same problem on a Windows XP / Office 2002 / Visio 200
configuration. Did you get an answer already ? I would like to know a
Thanks in advance...
> *This happens when attempting to copy a visio file to
> word, wheter link, embedded or picture.
> Then is brings up Task Msnager.
> What is is trying to tell me?
---------------------------------------------------------------------...sending emails from a word userform
I have created a word userform (in word 2007) and I need to send the data
from the userform to a list of employees using the outlook namelist (contact
there are 2 possibilities to consider:
1. opening the contact list in a stand alone computer
2. opening the contact list with activex control (for a big organization).
can someone tell me how to do that please?
If you are continually sending this data to the same bunch of employees, you
could set up a distribution list. Write the form data to a new document and
then call the following macro to send the d...How to get email statistics from exch2003?
I would like to know for last month,
1. how many incoming internet emails
2. how many outgoing internet emails
Wondering how can I check that on exchange2003?
On Fri, 13 May 2005 10:57:31 +0800, "Zac" <firstname.lastname@example.org> wrote:
>I would like to know for last month,
>1. how many incoming internet emails
>2. how many outgoing internet emails
>Wondering how can I check that on exchange2003?
You can get this information if you have Message Tracking enabled on
your servers. I...how to work writefile function with Microsoft Word
If we write any DOC file using MS Word i think we need
above functions.... Can anyone tell me what happned between WriteFile
& closefile functions.
if i hook WriteFile function & im using it like::::
BOOL WINAPI _WriteFile(
HANDLE hFile, // handle to file to write
LPCVOID lpBuffer, // pointer to
data to write to file
DWORD nNumberOfBytesToWrite, // number of bytes to write
LPDWORD lpNumberOfBytesWritten, // pointer to number of bytes...Text Encoding Problem
I asked a friend to translate a letter I wrote in English to Hungarian, and
she sent me back the translation via email.
I then copied the text from the email message in Entourage and pasted it
into a Word document.
All of the instances of a letter that looks like an o with a double
apostrophe over it (if it comes through this is it: ő ) in Entourage carries
over into Wrd as something that looks like a capital O and capital E
squashed together (if it comes through this is it: Œ ).
How can I get the proper character to display in my Word document ???
...get rid of paragraph indent...accidently in emails
Somehow there is a backwards P "paragraph indent" on my ermails, and I need
to know how to eliminate it....
"Dawn" <Dawn@discussions.microsoft.com> wrote in message
> Somehow there is a backwards P "paragraph indent" on my ermails, and I
> to know how to eliminate it....
That is not an issue with Outlook. That is an issue on how you
configured Word to show special formatting characters. The folks in the
Word newsgroup can tell you where is the option but might need more
spe...Difference between wmemcmp and memcmp
I was just wondering what the difference between the two? It seems
that both functions just take in bytes as their last parameter, and if
it does a raw memory comparison for the amount of bytes specified, than
it doesn't matter whether it is unicode or not?
Also, I am looking for a function that just compares memory one byte at
a time.. regardless of whether it is unicode or not.. what function
should I be using?
It seems silly to have wmemcmp since, as you pointed out, memcmp() is
If you want to compare arrays of Unicode characters, use wmemcmp()...