Time between two dates
I want to be sure how long has been since 1/18/88 to 9/30/05. If I substract
the numbers it says 9/12/17. Can I interpret that as 17 years, nine month and
17 days? It just that it looks as the answer should be 8 months and not
>Can I interpret that as 17 years, nine month and 17 days?
The result you see is due to Excel being "helpful" and using the DATE format
from the source cells and applying it to the formula cell.
The true result of the formula is 6465 days. When formatted as DATE, 6465 is
equivalent to the date of...need info on excel
Hi. This is my first time posting to this NG. I visited my accountant today
and he recomended me to get Microsoft Excel so that I can stay more
organized and present my tax figures easier. I dont know a thing about
excel. I have been doing things the old fashion way. I use COrel Word
perfect to do documents and make my own graphs and log info to that. But
I went to the web site and I beleive Excel 2003 costs about $200. to upgrade
is $109 or so. Is there a cheaper way to get this program or an alternative.
Please, is there anyone who can also tell me why excel is go good,what it
can ...Need to create a pie chart
I need to create a pie chart, and I am running into some problems. I
has been a long time since I have last done this, and was hoping tha
someone could help me.
I have a column named COMPLETED.
I this column it either has a Y or N.
I need to have a Pie chart so that it shows the % of Completed Y and
of Completed N.
I am having some problems coming up with how to set this up. I hav
tried the Chart Wizard, however I am just too confussed.
Message posted from http://www.ExcelForum.com
If your data are in A2:A100 (with A1 as a header), then in some empty
rang...Scan documents directly to excel
I am looking for a good OCR program that will allow we to
scan thousands of pages of phone bills diretly to MS Excel.
If anyone has any idea what I could use, I would
Hope you have a scanner with a sheet feeder.
Actually, faxing into the computer may work once you have OCR.
HP makes printer/fax/copier/scanners with OCR software as part of the
johnf202 at hotmail dot com
"Debbie" <DLLower@hotmail.com> wrote in message
> I am looking for a good OCR program that...Need to create an assembly call for Workflow Activity Creation
We're creating an Activity via a Manual Workflow on the Order. When creating
an Activity from that starting point, you only have access to fill a handful
of fields (Assign To, Type, Subject, Description, Priority, and Due Date).
We need the Activity that's created from this starting point to be able to
fill some customized fields that we have on the Task. The only way we
figured out that we might be able to accomplish this is by adding an assembly
call to the Worfklow. I'm not familiar with coding an assembly callout for
CRM in .NET. Does anyone know what resources I co...No date fields appear when exporting/importing CSV file?
I need to convert some legacy emails from another system to a format
that can be read by Outlook. The preferred format is CSV text, which we
plan to import into Outlook.
I noticed when playing with the export/import that the following seem to
be the standard fields that get exported into an Outlook generated CSV
"CC: (...Excel 97 to Excel XP (default margins)
I have excel files created in Excel 97. When I open this files wit
Excel XP, the margins are not the sames.
In Excel 97 are 0,0,0,0. In Excel Xp are 2.5,2,2.5,2
Can you help me?
Thanks in advance
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
I just did a quick test and margins set at zero in Excel 97 stayed at zero
in Excel 2002. Puzzled.
Could be a different printer driver from when the file was created in 97 vs now
in XP? Or even a differ...Excel formatting #3
Could someone please help with a macro or any other suggestion to format an
Excel sheet. Basically data is downloaded from a bank every week and the
size of the file can vary but the formatting is constant. That is each
record is 7 lines. So first record is line1-7, second record is line 8-14,
third record is line 15-21 and so on.
I need to format this data and basically I can record a macro for one data
set that is for the record on line 1 to 7. My question is how can I set it
to replicate so that it replicates for line 8-14 and then 15-21 and so on.
The source formatting remains the same...clash between different versions of excel?
Hi all. I created an excel document using excel2003 and save it in a file
server. As it is a shared file, it was opened by another user using excel97
for editing. However after the file was saved by the user of excel97, the
layout of the content in the file became very different compared to the 1
that was saved by myself when i was using excel2003. As the user of excel97
merely change the data without editing any layout, why did this happened? Is
it due to the different versions of excel being used? How can i solve this?
Thks in advance.
...create chart /table excel-save, close & reopen colors change? Why
When I create a chart/table in Excel - save, close & reopen to use again, the
colors have changed for my formating.
How do I set the formating so that the colors stay the same - I have tried
styles with no luck. The colors need to be the company approved.
Anne, I am unable to reproduce yr problem. Excel should NOT override yr
manual settings. However,you can set yr company colours as default under
Tools/Options/[Color tab]. Here are the colours Excel uses by default for
the workbook. (Under that thin line you see the defaults for fill and line
Hope this...qry for dates in 1st 2nd 3rd and forth quarters of current year!
Hello i am looking to write a query which returns values for the current year
DatePart("q",[Start Date],Year([start date])=Year(Date()))
is what i have written but this includes enteries for next year which i
dont need! any ideas please!!!
thanks in advance
> DatePart("q",[Start Date],Year([start date])=Year(Date()))
> is what i have written but this includes enteries for next year which i
> dont need! any ideas please!!!
You need to filter for the current year, e.g.
SELECT DatePart("q",[Start Date])
FROM [yourT...coalesce excel data
I developed a data logger for a computer simulation that people
interact with. The logged data is stored in a tab deliminated text
format. That data can be imported into Excel. I bring in different
subjects and have them test the simulation while I log their usage of
the simulation. I would like to be able to coalesce the logged data of
all the different subjects data into meaningful statistics about the
simulation. I can log the data by time or by room the person is in the
simulation. The data logged per time slice or per room is health,
amount of object 1, amount of object 2, etc. So it woul...Camera Tool in Excel
Hi, Please advise when using the camera tool in excel why would the linked
picture not change when the data in the original range changes
I am trying to create a dashbord, using the camera tool
Renier van Staden
In 2003 I cannot replicate your problem.
Which version of Excel and what are the steps you take to create a
Gord Dibben MS Excel MVP
On Wed, 30 Jul 2008 07:37:01 -0700, Renier van Staden <Renier van
>Hi, Please advise when using the camera tool in excel why would the linked
>picture not change when...Maximum Named Ranges in excel
I am using the Named ranges in excel to store metadata about each cell
in excel that can persist with the excel file. So 1 cell = 1 Named
Range.Advantage of using this approach is excel automatically updates
the name references, even if we cut-and paste cells.
As per this link(http://office.microsoft.com/en-us/excel/HP051992911033.aspx
), the amount of named ranges is limited only by
the amount of available memory.
I wrote a small macro that adds names to each cell in excel, considering an
average data of 10000 rows into 10 columns.
Like this: <short version...Ctrl-H crashing Excel 2002 fixed by Office XP SP3.
In thread "Ctrl-H crashes Excel 2002", a couple of dozen threads
before this one, I reported that, in Excel 2002 without Service Packs
After you do a search by Values (as opposed to Formulas), henceforth
Ctrl-H crashes Excel.
(You could prevent that by reassigning Ctrl-H to a macro.)
Thanks to Mike Mendelson & Dave Peterson, I found that Office XP SP3
fixes the problem. (I don't know which SP fixed the bug--1, 2, or 3.)
Now, Ctrl-H brings up the Search dialog without crashing.
...What Excel macro puts data in the NEXT row of a sheet?
I have a list of data in col B of sheet 2 which I need to copy and transpose
into sheet 1, then delete the data in sheet 2 to use the form again to copy
and transpose onto the next line in sheet 1. I have tried with a macro
shortcut I've called ctrl + e. (I am really using the data form process but
cannot because I have too many inputs).
Is there a simple macro I can copy and paste?
...Align Line Charts By Milestone Dates?
I'm a chart neophyte.
I have a worksheet with multiple line charts, each line depicting total
hours per month per project.
I would like to align the lines to a common milestone, like "start of
detailed design". Each project of course has a different date for this
Other than knowing that somewhere I'll have to specify the dates of the
milestone for each project, I have no idea of what to do.
Any help/insight will be appreciated.
Each data series has a column of dates and a column of percent complete
values. I'll use columns A and B in...Excel 09-06-07
Need some help please.............
in Column B you have a company names (different ones), then is say coulmn E
you have some figures like say number of kgs.
Is it possible to add all the figures from column E for each different
Column B Colum E
so you get say a months total of the kgs each company has done.
Use &qu...changing date range for budget
I need for an annual budget to be from September to
September not for the calendar year. Is there any way to
do this? I have money 2002. Thanks!
Unfortunately, the Annual Budget report appears to only display information
for the year selected.
However, you can customize the Monthly Budget report to cover 9/1 to 8/30
and report summary information. It won't be broken down by month, however.
"Shari" <email@example.com> wrote in message
> I need for an annual budget to be from September to
&g...Create new record
Just wonder if I press the * button on the record selector, is there a new
record already inserted?
I have a autoincrement field in a record, I would like to know if the new
record is really appended so that I can get the latest autoincrement number.
...Font property in Excel VBA causes 100 % CPU loop
I am using Excel 2002 SP-2 on a Windows XP machine running a Pentium 4
2.8 GHz processor with 1 Gb RAM.
When building a VBA userform, whenever I click on the properties box to
change the font size for e.g. a label or textbox caption, Excel starts
another process (i.e. I see another Excel process on the Windows task
bar) and consumes close to 100 % of my CPU.
The first couple of times I tried this, Excel eventually brought up the
font properties window (after more than a minute). The third time I
tried this, I had to crash Excel via Windows Task Manager.
At the time of trying to change the ...Colouring cell if it has a specific date
I have a column for each month where the dates are entered on rows. Is
it possible I can color a cell if the date entered in a cell for that
month is 15 days past the end of the month. Like, if in a January
column I enter a date on one of the rows as Feb.20, then the cell
fills with red colour.
I tried doing it using conditional formatting, but don't know how to
say 15 days past end of the month?
Any help will be appreciated! Thanks very much!
If column A is January. I don't know where you have your reference date
i.e. las...Excel Sheets
Is the number of sheets one is able to add to an Excel 2003 document
User wants to create a document with upwards of 400 sheets. Each sheet would
have about 10 rows, each row would have at least 1 calculation.
Is this feasible under Excel 2003?
The maximum number of sheets in a workbook is limited by available
By default the number of sheets in a new workbook is 3 but this may be
altered by using:
Tools > Options > General
Change to a maximum of 255
However, there is nothing to stop you adding more sheets.
Generally, you'll find things ge...ActiveX controls cause Excel to Shutdown
Last night I was doing some simple coding in VBA. The code applied to
two command buttons: one would copy and paste a line along with adding
a few check boxes, the other would delete said line and boxes. I
saved one of my first stabs at the code, and when I went to add
another command button Excel would shut itself down and auto recover
my previous work. I had been seeing the error "object library invalid
or contains references to object definitions" before this began
happening. I have Microsoft Office 2003 and have tried re-installing
it, to no avail. Every time I use the Activ...Date Calculation
I have two fields in a query: "Date Completed" (mm/dd/yyyy) and "Time Used
(hours)" (nn.n). I want to calculate a third field "Date Started".
Assuming an eight-hour day, the equation should be
[Date Completed] - [Time Used (hours)]/8
but I can't figure out which Date/Time functions
to use to convert my dates and hours to the same units
to do the calculation and then back to a date in the format mm/dd/yyyy again.
I am using Access 2007 and am not too competent with it. Thank you in
advance for your help.
A date_time is a data type, lik...