I assumed that NOW() in a cell (say A1) would produce a constantl
changing field, so if formatted as hh:mm:ss it would show the tim
changing.
Similarly if I enter SECOND(A1) in another cell it should show th

I am calculating times by dividing a distance by a speed. The results are in
cells formatted hh:mm but always seem to be rounded down so that the sum of
the column may be several minutes out, compared to the times displayed.
If I reformat the cells hh:mm:ss then I can see for ...

I need to create a warning when specific values sequences are input from a
drop down menu.  My example:
I have  31 columns (days in month) and have 25 rows (peoples names) from the
drop down box I have the following values-These are shift designations

I am trying to get a count of occurances. For example;
I have a schedule for 20 people for a month and have "N" in varying days of
the week and I need to have 2 separate counts for the occurance for each
person. One for the days Mon,Wed,Fri. and another for Tue,Thur & Sun. Then I

Thanks to a member I was able to insert a picture into the background.  But
now I need to know how do I format that picture.  I'm sure it's not
difficult, but I'm kind of new when it comes to excel.  Thank you for your
time.

=SUMPRODUCT(--(Sheet1!B2:B200="D"),--(Sheet1!C2:C200=4),D2:D200)
When I use this formula, the result is 0.
       A      B      C      D      
1              D      4      2

I have worksheets that represent different vendors. I need to be able to pull
monthly numbers out of worksheets and keep track of them. Here's the problem.
The invoices don't get put in to the worksheets in chronological order. There
may be 5 invoices in a row for the month of ...

I am trying sum a list of checks only if they were dated earlier than the
date in 'g2'.
This formula only works if i put an actual date
=SUMIF(Wachovia!G63:G114,"<7/15/06",Wachovia!J63:J114)  This works

i am having the following data in A1:B22
1000    DR
1000    CR
1500    DR

I have used the following code to give me a warning of duplicated values in a
column, at least I thought it should do this.  It does in fact give me the
warning in the column BUT it give me the warning if in the same row and this
is permitted.

work with multiple workbooks on separate monitors for 2003 edition.
I am not able to open multiple excell workbooks/sheets on multiple monitors.
My co worker told me she knew someone who was using the workbooks on multiple
monitors. please let me know how.

The Table will be filled filled                            
Item    LT    LH    LC   
3150169    ?    ?    ?   
3150173    ?    ?    ?   

have 15 digit numbers downloaded off scanner but need to insert a space
between 3rd and 4th digits.
3000 to do so how can i do it with function or formula
ie. 982123456789876 should be 982 123456789876

Which one is the ks for selecting all the cells in a column up to the last
used cell including blank cells in between?
Thanks

If I have a spreadsheet that contains a person's name, position, and hourly
rate is there a formula that I can enter that will automatically insert the
rate depending on the position I enter!  For Instance if I enter driller in
B2 under position is their a way to input a formula ...