parsing a date and time field #2
I am having trouble parsing the date and time in a field. I download
data from a data base and the date and time come together in one
field. I want to seperate the two. The date and time comes across as
the following: "2/1/2009 14:37" in the cell. When I parse it, it
seperates into three columns as follows: "2/1/2009", 2:37 AM", and
"PM" I can see what is going on but I would like to get two columns
with one as the date and the other as the correct time. are they any
ideas on how to address this?
Try using the TimeValue and DateValue functions.
First format ...Day of week time control
Let's say I wanted something to occur at specific times (via DDE) on Sunday,
a different thing on Monday -Tue, Wed, Thurs, Fri Sat and continue over and
I see how I can know the day and time, but to use it in a formula escapes
The use is for a simple area based light control in my house.
"vernon" <there@there> wrote in message
> Let's say I wanted ...Money Central Portfolio #2
My print function has gotten corupted. When I print it flips to WORD / format
and prints in a format that is 4x normal.
I am pretty new to using (or attempting to use) a Macro in a workbook. I am
having trouble following how and what to do to even start the process; ie If
there needs to be a worksheet already in progress or can I start from a new
THEN where to go from there.
Can I have some help in this area? Can some one supply me with a sample
Any help would be greatly appreciated
The best way to get started with macros is to use the Macro
Recorder. Go to the Tools menu, choose Macros, then Record New
Macro. Then, carry out some simple tasks and examine the code
that is produced.
...merging 2 cells without losing data?
How can I merge 2 cells without losing data from the other cell?
Not possible I'm afraid. Try placing the dat from both cells into one
and use "Center across selection" under Format>Cells>Alignment
Merge cells always end up causing grief. they are best avoided.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"bob" <firstname.lastname@example.org> wrote in message
> How can I merge 2 cells without losing data from the other...Statements #2
How are statements sorted? Alphabetically by name or by account number? Does
Any help is appriciated, Deb
Mine are done alphabetically by name.
"Deb" <Deb@discussions.microsoft.com> wrote in message
> How are statements sorted? Alphabetically by name or by account number?
> anybody know?
> Any help is appriciated, Deb
...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email email@example.com ��and
windows2003 + exchange 2003 Server "B" firstname.lastname@example.org user name is same in A
B��Mx record was be set ,question is how to config Exchange 2003 to receive
down the mail to Server A , because of we need to replace A with B.
thanks a lot.
E2K3 setup guides you through common scenarios (like yours) pretty much holding
your hand - on welcome screen tell it that you have existing E55 org and want to
join it, then follow on-screen instructions. Having usable backup of Exchange
databases and AD i...Network days
Is it possible to use the network days feature which Excel has in MS Access.
If not, how do I count the number of days between two dates, excluding
weekends/public holidays etc? Thanks.
Take a look in the Date/Time section of "The Access Web". There are a couple
of solutions there. http://www.mvps.org/access/
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"C Tate" <email@example.com> wrote in message
> Is it possible to use the network days feat...How do I make a chart with several times during a day
This seems like it may be a simple thing, yet I can not for the life of
me figure out how to do this (or at least semi-easily with VBing it for
I have a simple table filled with the following information (example
12pm 5pm 10pm
11/20 5 4 7
11/21 5 4 7
11/23 5 4 7
11/24 5 4 7
11/25 5 4 7
So basically I am keeping track of a numeric value three times a day. I
would like to make a chart of it with...Macro
Here is one for you experts - I am a novice
I want to add a macro to a worksheet that will print selected information
held on certain rows of the worksheet.
Once the 'button' has been selected a mesage box will pop up asking the user
to input which row number he/she wishes to print.
On input that number is matched to the corresponding row of the worksheet
and that row is copied (without any formula - just cell values) and pasted
into another worksheet where it is placed into other formats and printed.
Seems like a simple(!!) job - but far to difficult for me to programme
Can an...Opportunity Product
I have a question (or problem, I don´t know), in the Opportunity Product
form, I need to add a Percentage disccount instead of an Amount
(manualdiscountamount field), is this possible?, if yes, how can I do it?.
This is very urgent for me and I´ll really appreciate any help.
Thank you in advance.
On Apr 20, 2:51=A0pm, AlexMC <Ale...@discussions.microsoft.com> wrote:
> I have a question (or problem, I don=B4t know), in the Opportunity Produc=
> form, I need to add a Percentage disccount instead of an Amount
> (manualdiscountamount field), is this po...Sum amount if = 2 value's
I have a spreadsheet of payment types for which I want to sum the tota
amount per type per month
A B C
Type Amount Month
I'm able to get the total amount per type by usin
=SUMIF(A:A,"TYPE",B:B), but can't work out how to get a total for eac
type each month
Somthing along these lines: =SUMIF((A:A,"TYPE",B:B)&C:C,"MONTH")) ????
loscherland's Profile: http://www.excelforum.com/member.ph...Excel pivot table #2
i encountered an error in my pivot table.
i created an olap cube using the analysis manager.
the cube displays the correct data of my measures but on my
pivot report, it displays #N/A....
i need help to fix this one... thanks.... =)
...Limiting CRM application ability to aasigning user to approprite CRM security group
IT administrator that I have for client does not like the idea of CRM
application assigning user group automatically. They prefer to do the
security group assignment manually.
Is this possible? What do I need to do to achieve that?
I did it the following way for a customer:
1) You will need to precreate the five groups within your AD. There is no
need of having a own OU (Container, Organizational Unit) for them. Follow the
naming convention of your company or use the default namings from Microsoft
for the five groups. There is no need for your AD Admin to assig...Outlook Express 6 Spell Check #2
I am using Outlook Express 6 on Windows XP, and I have a
problem with spell check. When you send an email, it
says "spell check has been haulted, do you want to send
anyway" and if I ask it to spell check, it says an error
has occured in spell check. All my spelling options are
correctly set, so I don't know what the problem is.
Kimberly McNabb <firstname.lastname@example.org> wrote:
> I am using Outlook Express 6 on Windows XP, and I have a
> problem with spell check.
Ask in an Outlook Express newsgroup.
I'm new to Outlook.
I hear of an Outlook database in other threads. Is this synonymous with the
..pst or .ost files people mention?
Does it corrupt often and if so are there tools to repair it?
There's a utility called ScanPST.EXE that will scan and attempt to repair
Yes, typically when a user says Outlook database they're referring to their
"Craig Roberts" <email@example.com> wrote in message
> I'm new to Outlook.
> I hear of an Outlook d...unique with 2 columns
I have 2 columns with duplicates in the first column and no duplicates in the
second. I neeed to only see one value for each in the left and only one of
the accounts from the right.
ie: abc 1234
I would like to see either of the abc with the 1234 or 12345
I would like to see the bcd since it's individual with the 251
I would like to see either of the eft with the 600 or the 607
Use a totals query and one of the aggregate functions (First, Last, Min, or
Max) on the...host unreachable #2
if i send a email with a wrong address or mispelled it, i
don't get a message that the address, destination is wrong
until 4 days later after being deletedj from the outgoi
im using E5,5 sp4
Is that for all domains, even for Yahoo and Hotmail?
> if i send a email with a wrong address or mispelled it, i
> don't get a message that the address, destination is wrong
> until 4 days later after being deletedj from the outgoi
> im using E5,5 sp4
...Excel number formatting #2
I receive spreadsheets with separate columns of numbers
and text. The problem is that the numbers column is not in
number or general format (when sorting behaves like text).
Is there a way to turn those columns into numbers (except
stepping into each one separately)? When I just highlight
the number in the cell and hit enter, the cell
automatically becomes numeric (I'm looking for a more
You can do this:
1. Type 1 (the number 1) into a blank cell. Highlight this, select Edit,
Copy. Now highlight entire column(s) that you want changed to numeric, and
sel...How to relate an Activity to a group of contacts?
Is there a way to easily attach an Activity to multiple Contacts. For
example, how can I attach the same Task to all the Contacts in New York?
Selecting contact by contact is much to time consuming
you would need to write an addon to do this.
Microsoft CRM MVP
"NBCRM" <NBCRM@discussions.microsoft.com> wrote in message
> Is there a way to easily attach an Activity to multiple Contacts. For
> example, how can I attach the same Task to all the Contacts in New Yor...Closing Excel #2
I have inherited an App desigend by an ex employee
Sometimes the program leaves Excel in the task manager
The programe uses various routines and calling various functions that define
Excel sheets etc (badly named)
I'm finding it hard to follow (my 1st experince of .NET)
is there a way to KILL any Excel instence when exiting the program.
I have come across some posts about GC (garbage collection)
oXLWsheet = Nothing
oXLWs = Nothing
oBook.Clos...hidden transactions #2
I have a problem with account balances: the balance for checking is way off
on the hiome page than in the account register view. When I tried to find out
why, I got some greyed out transaction when I went from bill schedule through
right click to payee. This transaction cannot be changed or deleted, but in
total all such transactions made up the difference in balance.
In microsoft.public.money, elvigor wrote:
>I have a problem with account balances: the balance for checking is way off
>on the hiome page than in the account register view. When I ...Sending to Distribuiton group from outside the domain fails
Hi, when trying to send to an internal distribution list from an email
address outside of our domain the mail does not get through. The error
returned from Gmail in this case, is:
Technical details of permanent failure:
PERM_FAILURE: SMTP Error (state 9): 553 Requested action not taken: mailbox
name not allowed or chunk too large
How can I allow email to be sent to a distribution group from outside of our
do you have the group restricted to receiving email only from authenicated
Susan Conkey [MVP]
"Paddy Ryan" <firstname.lastname@example.org> wrote in m...Stats/PivotTables #2
I have to produce stats from data exported as a CSV file from a piece
of custom made software we use here.
The data displayed in Excel looks like this:
01/04/2003 05:31 Dr JESSICA STROUDLEY
01/04/2003 08:56 Dr JESSICA STROUDLEY
01/04/2003 11:16 Dr JESSICA STROUDLEY
02/04/2003 11:42 Dr JESSICA STROUDLEY
02/04/2003 05:31 Dr JESSICA STROUDLEY
02/04/2003 08:56 Dr JESSICA STROUDLEY
03/04/2003 11:16 Dr JESSICA STROUDLEY
03/04/2003 11:42 Dr JESSICA STROUDLEY
I have to produce a spreadsheet saying how many examinations were done
by a particular doctor over a certain timespan. Each date li...How did I break the cell display limit? #2
If there is anyone out there who can help with this, I would be most
most grateful. Here's the facts:
- I'm working in a MS Excel worksheet.
- I am aware of Excel's 255-character-per-cell display limit. (As
understand it, each cell can hold up to 32,000 characters, but wil
only display/print 255 characters.) This is a major pain in th
petunski, as most of my cells contain more than 255 characters
Therefore, most of my spreadsheet shows cells that look like this
###############. I have to look in the formula bar to see the actua
contents of each cell.
- In cell C35, I have 1,05...