Newbie Time Question #2

Great Info. Thank you very much.

Any books you could recommend that would help me in understanding 
creating formulas like this?  I would like to get more out of excel 
this is great stuff.  Most of the books I see are a general overview o
the application.... Unless I looking at the wrong stuff

--
ACangem
-----------------------------------------------------------------------
ACangemi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=858
View this thread: http://www.excelforum.com/showthread.php?threadid=26314

0
9/25/2004 7:40:12 PM
excel 39879 articles. 2 followers. Follow

2 Replies
579 Views

Similar Articles

[PageSpeed] 40

There are a few books on Excel formulas listed here:

http://www.contextures.com/xlbooks.html#Functions

ACangemi wrote:
> Great Info. Thank you very much.
> 
> Any books you could recommend that would help me in understanding &
> creating formulas like this?  I would like to get more out of excel &
> this is great stuff.  Most of the books I see are a general overview of
> the application.... Unless I looking at the wrong stuff!


-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

0
dsd1 (5911)
9/25/2004 9:07:48 PM
Hi ACangemi,

As well as the source that Debra gave you, you are looking at the best
source of learning about Excel that I have found - these Newsgroups!

Regards

Sandy

-- 
to e-mail direct replace @mailintor.com with @tiscali.co.uk

"ACangemi" <ACangemi.1d5mta@excelforum-nospam.com> wrote in message
news:ACangemi.1d5mta@excelforum-nospam.com...
>
> Great Info. Thank you very much.
>
> Any books you could recommend that would help me in understanding &
> creating formulas like this?  I would like to get more out of excel &
> this is great stuff.  Most of the books I see are a general overview of
> the application.... Unless I looking at the wrong stuff!
>
>
> -- 
> ACangemi
> ------------------------------------------------------------------------
> ACangemi's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=8583
> View this thread: http://www.excelforum.com/showthread.php?threadid=263148
>


0
sandymann (252)
9/25/2004 9:30:26 PM
Reply:

Similar Artilces:

update trigger question
If I have something like this in an update trigger: if update(FirstName) or update(LastName) begin update n set FullName = i.FirstName + ' ' + i.LastName from Names n inner join inserted i on n.NameID = i.NameID end I only want FullName to update if either FirstName or LastName are updated. Here's my question. A batch update updates 50 rows in the table. Of the 50, only 20 have changes made to the FirstName or LastName columns. It's my understanding that the "if update()" ONLY allows 20 rows that fit the if update criteria to be updated in the...

Computing formula for time
I have three columns: StartTime, EndTime, TimeTaken and the format of all three is "time" Now i want to compute the time taken using start time and endtime. i.e timetaken = endtime - starttime Can anybody tell how to add funtion for this in My sheet. i.e on entering endtime and starttime i should get the time taken Rohit Hi Rohit! The following return the answer in time serial numbers representing decimal parts of a day. =B1-A1+(B1<A1) OR: =B1-A1+IF(B1<A1,1,0) OR: =MOD(B1-A1,1) In all cases we can choose the time format to be displayed. hh:mm:ss displays 09:15:00 h:...

Updating Accounts #2
I just upgraded to Money Plus Deluxe (Have XP) When I go into Money it states its "updating account" and my CPU usage is at 99% when I run Money. There are NO accounts that are being automatically updated as I do them all manually. The "updating accounts" icon stays up until I finally have to turn off computer because I cannot work on any other part of money as it says it is doing an online function. PLEASE HELP.. It also goes online to seek its own updates. Do you have SSL2 enabled in Internet Options? Do you have firewall software enabled beyond the XP firewall...

Multithreading Question
Hi, I am writing a multithreaded server application. I have written a class to handle thread(CThread , say) activities like creating, suspending, resuming threads etc. I have derived a class from CThread (CMainThread, say) and a class (CClientThread, say) to handle client connection which is also derived from CThread. In CMainThread class i am creating a thread and waiting for incomming connections. As soon as a connection came i am creating an object for CClientThread and call the function to create a thread and so on. code flow: 1. Start the main listening thread. 2. wait for a con...

Custom Button #2
Hi I need help to creat custom Button for some of my item code/Item description What sould I put on Comand ? Hello: http://www.microsoft.com/BusinessSolutions/RetailManagementSystem/rms_create_custom_button.mspx Wilfredo "Gill" wrote: > Hi > I need help to creat custom Button for some of my item code/Item description > What sould I put on Comand ? Don't know if you found your answer but this is how you do it: Leave ItemID as 0 and just put in the ItemLookupCode, if you want a Matrix put in the MatrixLookupCode. PerformAddItem 0, ITEMLOOKUPCODE, 1, 0, 0, 0, 0 Rob ...

How do i access microsoft excel on windows xp? #2
I recently purchased a pc that came with windows xp home. I thought the microsoft excel programme would come with it, but i can not find it anywhere. Does this mean i have to purchase it seperately? Yes; or as part of Microsoft Office. "ayanda" wrote: > I recently purchased a pc that came with windows xp home. I thought the > microsoft excel programme would come with it, but i can not find it anywhere. > Does this mean i have to purchase it seperately? ...

MS CRM Certification question
Hi all, I have a question regarding the CRM certification? What, if any, certifications are there available with MS CRM? Is there anything like CRM Professional? Have I earned any certification if I passed the Applications Professional exam? T.I.A -- Kuba Skalbania [MCAD] ...

Dateserial same every time
I don't know what I am doing wrong but I am using DateSerial as a default in a textbox and no matter what I keep getting 1/31/2010. I have tried to put in anything just to get it to be something other than 1/31/2010...DateSerial(Year(Date()),Month(Date()),0) AND DateSerial(Year (DateField), Month(DateField)+1,0) AND even tried to hard code DateSerial (2005,12,12)...still got 1/31/2010! What I doing something wrong? Thanks in advance... -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201002/1 I can understand why you...

Excel File #2
unable to open xls file from shortcut or explorer will only open from withing excel I have changed the options / general / ignore other apps still the same issue thanks in advance Sometimes one of these works: Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets the windows registry to excel's factory defaults. ==== You tried the first, how about the second??? Mj wrote: > > unable to open xls fil...

how to aviod outlook pst file created locally? #2
I am using postfix as MTA and storing pst file on server. But everytime there is a network problem (ie. disconnect), outlook will create a new local pst file(coz it can't find the network path to the pst file). Because of that i had to manually go to reconfigure the default delivery to the correct path (after network back on line). I just want to know if there is a way to aviod outlook to not create a pst file while user still able to open outlook? Or is there a way to allow outlook automatically look for the pst on network (when LAN connection resotre)? Its a pain to manually re-configur...

Really simple questions re CSliderCtrl
Using SetSelection() I can get a CSliderCtrl to display a highlighted selection ... but so what? What use is it other than to look pretty? Which of the following is possible, and how do I do them? (1) Prevent the user from moving the thumb outside the highlighted range. (This seems to be what the documentation suggests that SetSelection does, but in fact it doesn't, the thumb can be moved outside the selection.) (2) Have the user change the selection. (The documentation seems to suggest this is possible, but I can find no combination of keystrokes or mouse actions that will do it.) -- ...

Newbie, accnts. payable & accnts.receivable sample DB
Hi guys, I�m running access 2003, windows xp pro SP2 I've been commission in my work to do a small application to track and report the accounts payable and accounts receivable movements, I'm not an accounting savvy person :(, does anyone know of a link or sample access database that can help me with the basic structure of the tables and reports?, any help would be greatly appreciated. Thanks ...

Count No. of times Dates are repeated
Hi, I have a database where in dates are repeated in column D and names in column I. I want a formula in a different worksheet of the same file wherein I get the count of dates column along with the individual name. The intention is to get number of days each individual is present. The same dates could be repeated any number of times for the same individual. Example for the month of Dec. 2005 Dates Names 20 AD 15 BC 08 GH........etc Cheers, Mandeep Dhami Have you considered a Pivot Table? Data>Pivot Table Use Excel Select your data Click the [Layout] button ROW...

Email Setup Questions
Howdy and Happy New Year! I just bought a new computer and I'm trying to set up Outlook. Other than logging onto work email using the internet from a hotel o at home, I've never used Outlook away from work. I have several different email accounts: Hotmail, AOL, and work emai (which uses Outlook). Is it possible to utilize Outlook to retrieve my emails from th separate accounts? Can I setup each of the folders for the differen email accounts all on the left side? After I set it up, how does Outlook know which account I'm using when send email? Hotmail? Work? I need h...

Old emails sent out after reboot #2
I have a strange problem that I haven't been able to resolve yet. I recently updated my Exchange 2003 SP2 server with the latest patches from MS. After a reboot all the messages that had failed to deliver (timed out after 48 hours) were retried and many of them were sent since the servers that were unavailable were not working on the Internet. This was pretty bad since some of these were from month's ago. Has anyone ever experienced anything like this? Thanks, -Will73 On Tue, 7 Nov 2006 07:43:01 -0800, Will73 <Will73@discussions.microsoft.com> wrote: >I have a str...

Military Time in Excel
I would like to create a timetable in Excel with the format in the 24 hour clock without the colon, which I believe is known as military time. I am leaving the colon out for a number of reasons, aesthetic and to speed up entry. I wish to enter the time, for example, 8:30 am as 0800 and have Excel interpret it as a time, as these will be graphed, so need to be interpreted as time, and not plainly a number. At the moment Excel simply shows "800" when I type 0800. I have tried formatting all the cells as Custom "hhmm" instead of "hh:mm", but when ...

Rules don't work #2
I've read a few posts and haven't seen any useful advice. I've created the following rule: When messages arrive, forward to user@domain.com when from anotheruser@domain.com. The rule works fine, if I run it manually. It doesn't seem to work, however, "when the message arrives." My other rules are working fine, but some of the users in my office are having this problem occasionally. We are all on XP, using Outlook 2003 or 2000. Can anyone shine some light? -- Wack ---- This message will self destruct. ...

=?GB2312?B?uePW3c3+tvjQxb6rw9zSx8b309DP3rmry74=?= #2
uePW3c3+tvjQxb6rw9zSx8b309DP3rmry77Kx9K7vNLXqNK1yfqy+tSy1vm2yNLHLMLWwKrSxyzU srbI0scszbnC1tbhsuLBv9LHLL6rw9yy4r3H0scsu+7I+9DOz9+y4sG/0scs1uGz0NXxtq/Sx7XI vqvD3LLiwb/Sx8b3tcTW0M3ius/Xyg0KxvPStaGjuavLvrXEy/nT0NLHxve++c6qsb65q8u+19TW 99HQt6K1xLPJufss08nTtdPQyv3KrsTqvqvD3NLHxvfR0Leivq3R6bXE18rJ7teovNLX6bPJ0dC3 os3FttMs1Nqz5LfWzvzK1bn6zeLNrMDgsvrGt7XEvLzK9dPFteO1xLv5tKHJzyyyqQ0KssnW2rOk tvjR0LeitcSho7mry77Gvr3ouN/Gt9bKoaK5+rzKz8i9+LXEvqvD3LLiwb/Sx8b3us2/7L3d1PbW tbXEt/7O8SzTrrXDwcvL98ThoaLLyc/CoaLI1cGioaLDwLXEoaK/xsH6oaKyqcrA1tC5+qGisqnK wLOkybOhos3ysabWwbXnu/qhorXZDQrJrb/LwrKyrryvzcWhosGqz+uhosnPx...

Visio Newbie
Hello all, this is my first time using Visio for drawing a floor plan and I have a quick question. Yesterday, (Using a tape measure) I mapped out the floor plan of an office my company might be moving into. I wrote everything down in Inches. Is there a way once I get a room shape kinda close to teh measurements, that I can manually type in teh length for each wall? if not in inches, at least in feet. For example, I have one wall that is 154 inches ( 12.83 ft) Then the next wall is 242 incehs( 20.1 ft) The opposite wall of the first measurement is 288 inches, third wall 100 inches, then 13...

counting how many times a certain month appears
Hi all, Fourth try's a charm....I'm getting errors trying to post my question. Here it is... 1 workbook, 4 worksheets each named for a different office. Column A for each sheet is the date in the following format 03-May-10. I need to count how many times May appears in column A, range A3:A5000, from the 'Montreal Office' worksheet. I thought I could use =countif but from other posts, it seems maybe =sumproduct is the better option. I need your help. My stats are due pretty soon. Looking forward to your replies. MM Yes, you want to use: =SUMPRODUCT(--(MO...

SFO synch questions
When SFO synchronizes with CRM server are all records updated? or just the modified ones? and if i change some fields in one record and another user changes other fields in the same record, does it keep all the information when both go online? thanks in advance. My understanding is as follows When SFO syncronises with the CRM server it uses a method called 'playback' to write changes only back to the CRM server. It syncronises at a field level for only the modified records The current issue with sync will only affect a record if the same field on the same record is updated whil...

Weighted Average #2
I am new to the weighing of numbers using excel. I really need help. I am able to do this manually, but I it takes too long. Yes I still use the calculator instead of excel. I am new at this. Please help. I need to figure out the Quaterly total of the Average second. Manualy, I divide the total of the month and divide it by quaterly total then this number is the multiple by the months average second. And I repeat for all months. I then add and this is where my 0:18 comes from. Please help if this makes sense. Total Average seconds October 7,727 0:26 November 6,292 0:12 December 5,4...

file will not save #2
I moved sheets from a number of different files to a new workbook and now the file will not save. Have you saved the new workbook first? "ned kelly" <ned kelly@discussions.microsoft.com> wrote in message news:91BD6231-3FC9-4F51-B145-AE496FF8937F@microsoft.com... > I moved sheets from a number of different files to a new workbook and now the > file will not save. ...

RMS 2.0 startup error
Hi, I get a small box opening up with the word "setwaitchar" in it and "Incorrect function" as well. Eventually if I persist by clicking it a million times SOM or POS opens. Any clues this pain -- Regards Dan Levin ...

Time Sync help
Does anyone have an example or article handy of a way to sync workstations time w/ a server? Are you talking about a Server and WorkStation that you have created. If so I have done the exact code in the past, however, not sure if I can help. It all depends on how your server and work station communicate. This can be further complicated if you have a server running along with several work stations.. across time lines. "Kelly Brimstone" <kellybrimstone@yahoo.com> wrote in message news:7d3b4b05.0309021126.49bb14d7@posting.google.com... > Does anyone have an example or articl...