Time to Number Conversion
I run Excel 2K
I download data from a mainframe.
One of the entries that is download is a value that represents minutes (or
hours) that reflect the duration of a process delay.
0:47 (which represents 47 minutes.
8:23 (which represents 8 hrs and 23 minutes)
Here is my problem.
Although it shows 0.47 in the cell, in the edit bar it shows 12:47:00 AM.
as does 8:23 show as 8:23:00 AM.
I need a formula that can look at these cells and convert them to a number
format of actual minutes. These numbers will then be totalled using a pivot
Is this possible?
...How to convert text to number format
I copy a table of numbers from web to Excel.
They appear as text and I can't do algebric command on them
(For example their "sum" become zero)
I know it is possible to change number format to text format but is there
any command to convert numbers to texts so I can sum up them?
Changing the format from:
Format/Cells Number tab and category box doesn't help.
Any comment is appreciated
Copy an empty cell. Select your range of data. Paste Special>Add>OK>Esc.
Gord Dibben Excel MVP
On Tue, 13 Jan 2004 00:00:54 +0330, "Rasoul Khoshravan Azar&...Averaging times that are not in a range
I am trying to get an average response time for numbers that are not listed
in a range. They are formated as a custom format like this: h:mm:ss. I have
been able to get a range to work, but not durations that have other cells
between them. Below is a picture of my table. The three center times,
Dispatch Time to On Scene, are the times I would like to average. Can you
please help me with the correct calculation? Thanks!
Tk-1 - Sta 1 - 96 Acoma
Dispatch Time to Enroute 0:01:29
Dispatch Time to On Scene 0:06:00
Total Time-Dispatch to Available 0:29:15
E-2 - Sta 2 - 2065 Kiowa ...Money Plus Primium in Retail Stores
When Will Microsoft release its new MS Money Plus Premium product in the
...GP10 Security Best Practices Question
I have read up the KB articles on the new role-based security with GP10 but
have some questions.
If I upgrade but choose not to convert the old security, what is the
quickest/best way to get up and running with fresh GP10 security?
I have about 50 User-Id's that will need updating.
There is no "quick and easy way" around security in any GP release. For v10
in particular, I would suggest you start to look at the tasks and roles
performed by your users then compare those to the existing tasks and roles
created under the new security model, then ass...Best procedure for forwarding email of fired sales employee?
We recently fired a sales employee and now I need to make sure his manager
receives all the emails. What's the best practice for handling this type of
situation. Should I give the manager rights to the fired employees inbox
and add another mailbox withing Outlook, or is there a better way to handle
Add the old SMTP addresses to the managers mailbox. ( changing the
existing ones in the fired employee's mailbox first of course)
On Mon, 28 Feb 2005 15:55:33 -0800, "Colin" <email@example.com> wrote:
>We recently fired a sales employee and now I need to ...preview pane + HTML content = slow response time ?
I've outlook 2003, when I click on an email with an HTML content, outlook
stop responding for 2-3 seconds before displaying the content of the email.
but the problem does not appear on all HTML message, but sometimes yes,
any idea of the problem ?
how to resolve the problem?
Do you have images blocked (the default) or are they loading? Does it seem
to be specific types of HTML - i.e., more complex html can take longer to
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Window...How best to find out who did what when
I'm trying to satisfy the boss who wants the ability to find out "who
did what when" on our DBs. Essentially this request is calling for
24x7 monitoring. Any advice out there please? Should I profile (and if
so what events etc) or poll sysprocesses in an indefinite loop? Are
there any other options?
Thanks from an accidental DBA.
nzrdb6 (firstname.lastname@example.org) writes:
> I'm trying to satisfy the boss who wants the ability to find out "who
> did what when" on our DBs. Essentially this request is calling for
> 24x7 monitoring. Any ...Who has the best deal for Money Plus 2008?
Who has the best deal for Money Plus Deluxe / Premium versions? I cannot
see Money Plus at Costco anymore.
I've never seen it at Sam's either, which seems unusual. Since I'm on
version 2006, I'm hoping 2009 will be a good one.
> Who has the best deal for Money Plus Deluxe / Premium versions? I cannot
> see Money Plus at Costco anymore.
On Oct 8, 12:12?pm, ameridan <ameri...@discussions.microsoft.com>
> I've never seen it at Sam's either, which seems unusual. Si...Conditional Formatting of Charts
Is there anyway that I can conditionally format a chart?
What I need to be able to do is set parameters for the
colour of a data series. For example I have a chart
showing total daily sales plotted on a day by day basis. I
want to be able to set the colour for each days sales
depending on the amount i.e. if it is over 500, then it
will be green, between 350 and 499 amber, and anything
below 350 will be red. I know this can be done on
individual cells, but can it be done in a chart?
All help greatly appreciated.
I have a couple approaches on my Chart Formatting page:
...I get multiple copies of the same email every time I open outlook
I get my yahoo mail in outlook and every time I open outlook it looks and
receives all mail in my yahoo address. So it doubles my mail every time I
open it! HELP
Rick <Rick@discussions.microsoft.com> wrote:
> I get my yahoo mail in outlook and every time I open outlook it looks
> and receives all mail in my yahoo address. So it doubles my mail
> every time I open it! HELP
WHat version and service pack level of Outlook? Have you enabled the
account option to leave messages on the server?
...Excel worksheet function
Can I protect my worksheet in Excel and enable the spell function...
Only by using VBA macro code.
Requires VBA to unprotect the sheet, do the spellcheck then reprotect the
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
If not familiar with VBA and macros, see David McRitchie's site for more on
http://www.mvps.org/dmcritchie/excel/getstar...convert to stored proc
Hello. I have been given a conversion assignment to convert Access db
(frontend) with sql server 2005 backend to be included in a new webapp
that is being constructed. Unfortunately, my stored proc creating is
a bit weak and I'm not afraid to admit it. With that said, I came
across an Access query that is puzzling me. Here it is;
SELECT Purchase Orders *,
POSO Relationships.SONumber AS RelatedSONumber,
IIf([POSOType], [POSOType], 'Standard') AS POSOTypeFull,
...Hyperlink created in Access does not function when printed to pdf
I have a database in Access 2007 in which I created a field that hyperlinks
to Google Maps for an office location. In Access database, the hyperlink
works perfectly. When I print the report to Adobe PDF, the link cannot be
accessed. I have a similar field that opens our e-mail program and generates
an e-mail. THAT works, but the hyperlink does not.
I hope this makes sense.
Thanks in advance.
You could use a different pdf printer driver. For example win2pdf will take
any text that looks like a hyperlink and change it to an actual hyperlink in
the pdf file.
I assume t...Best research method
I have 2 sheets in excel with around 20.000 records each.
I would like to research on "sheet A" if data on "Sheet B" exists.
for that i want to use 3 criteria from sheet B and search in sheet A.
if found, i will do something from sheet B to Sheet A.
i tried to use autofilter but it is very slow method for 20.000 records. i
tried also to scan 1 by 1 but it is worse...
Have you got some idea how can i speed up this research ?
thanks a lot,
I think you will need to explain in a bit more detail exactly what it
is you want to do.
How do I change the date format to 10-Nov-2003 instead of
11/10/2003 in Outlook?
change the date format in windows control panel, regional settings.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, Visual Quick Start Guide - OneNote 2003
Outlook Tips: http://www.outlook-tips.net/
http://www.poremsky.com - http://www.cdolive.com
Expert Zone http://www.microsoft.com/windowsxp/expertzone
Search for answers: http://groups.google.com
Most recent posts to the Outlook newsgroups:
http://groups.google.com/groups?as_ugroup=microsoft.public.outlook.*&...Word Crashes When Formatting Styles from Templates in the Project Gallery
Operating System: Mac OS X 10.4 (Tiger)
I wonder if anyone has seen this. <br>
--------------------------------- <br><br>I can reproduce a crash of Word with many forms stored in our Project Gallery (PG) that have a style. I tested this with a newly created form and older existing forms. <br><br>Steps: <br><br>1. Create New Document <br>
2. Add Form fields <br>
3. Create a new paragraph style <br>
4. Apply style to some text <br>
5. Lock the form <br>
6. Save as a .DOT <b...Best Approach?
Hi all, thanks for all the great advice I've gotten here. Every day my MFC
skills improve! Long way to go yet though...
I have an database app I created. It uses a form view with a list and tree
control, everything works well so far.
I want to have a way to generate a printable report, though. How best to
implement that? IOW, I could have a dialog w/ a rich edit cntrol for the
user to see the report, but I was wonder if there's a better way to do this.
I don't really need editing functionality, just a way to look at and print
the report, and possibly save it. How pra...Description Field Displaying All (Not One At A Time)
How can I display the description field for all queries and tables at one
time. We (our company) utilizes the description field as a source for
instructions, tables use the field to list where source data is obtained,
queries use the field as a instruction field for which queries to run and
which order, ie Step 1 - Appends data from... Step 2 - Summarizes and groups..
. etc. We used to sort by description so that steps would be in numerical
order. Its not as important for us to be able to sort on the description
field as it is for them "ALL" to display at once. If this is ...Losing formatting input an ntext field in a e-mail template
I have created an email template with and I want to display the information
of a Ntext field in the e-mail.
I created the e-mail and insert the template, after inserting I lost the
formatting of the Ntext field (missing enters/breaks).
Does have anyone a solution?
I have started running into this exact same issue. Haven't found a
resolution yet. Please let me know if you find something. I'll do the same.
> I have created an email template with and I want to display the information
> of a Ntext field in the e-mail.
> I created the e-mail...Hoe to change text format .126 to number format 0.126
I has a column of data full of:
--> all in text format.
Is it possible to have some equation to change those data to:
--> as number format.
vitality's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27267
View this thread: http://www.excelforum.com/showthread.php?threadid=473711
Assuming that your data is in column A, in B1 put
and formula-copy that for the length of your data, the format 0.12...Access 2007 installs every time
I downloaded the trial version of Access 2007 and now it seems to be
installing itself every time I open it. This takes half an hour or so. How
can I stop this installation from occurring every time I open it?
...Conditional Formatting with Relative Reference.
Conditional Formatting with Relative Reference.
A B C D E F
1. 4.5 6 7.4 8.3 10 2
2. 1 2 3 4 3 2
3. 1 2 3 4 5 6
4. 6 5 4 3 2 1
How can Excel 2003 workbook be designed so that if a value of a cell is
smaller or greater than the value of the cell, then color of the cell is
auto formatted ?
Formatting of the cell is as follows: Green if value is greater and Red if
I'm passing on the good word to other exchange admins since my company
switched to Message Labs. It has FAR outperformed all other traditional smtp
gateway a/v scanners at least in my experience - www.messagelabs.com
I've deployed it at a 30,000 seat company.
Message Labs "skeptic" engine doesn't operate like traditional a/v scanners
which require users to report e-mail viruses to the vendor for a pattern
update to be released. It uses a 2gb heuristics engine that actually detects
unknown, new viruses.
...Inexact? InsideTop and InsideLeft Method of PlotArea (Excel 97)
:mad: I am having a problem of using InsideLeft and InsideTop method o
a PlotArea of a PlotChart. It doesn't give out an exact value, alway
offset by a bit. Fairly annoying, is it a bug of Excel 97
jintao's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2539
View this thread: http://www.excelforum.com/showthread.php?threadid=38866
It might be the difficulty of measuring in points a rectangle that's internally
defined by the pixel density of the screen.
How do you mean it&...