I am trying to calculate the time for a time sheet and billing purposes. i
need to know the hours between 7pm and 7am
Currently we are using standard time sheets ex. Start: 7:00 end 20:30... i
need to know and seperate out the time between 1900 and 20:30 to get in

We are working on excel 2003.  We've shared the file, which is located on a
network drive.  Everyone has access to the network drive.  Everyone can
access this excel document but one person.  This person gets an error when
trying to open the file.  The error says the the file ...

I have a spreadsheet (Excel 2003) that imports time data from another
application in the following formats displayed on the formula bar; for under
one hour, it displays mm:ss  When the time is over one hour, it displays
h:mm:ss AM (or PM). When I apply conditional formatting, I ...

I am trying to create a formula that will create the following:  Column C
Date of birth mm/dd/yyyy, Column D (elected percentage) Column E
Compensation, Column G Emp contribution . The match 100% of 1st 3% and 50% of
next 2% No match over 4%.  If the Column D (elected percentage) ...

I am trying to do a selection formula.  It is for hardware.  I have a
workbook set up where I have different tabs, and I need a part number to
return based upon both size and thickness that is stated by the user.  
For example:

I'm trying to compare sales from 2007 vs 2008 with a percentage change.  I'm
really trying to get the 2007 monthly sales numbers to update automatically
according to the date in 2008.  In May, I want the weekly sales for 2007, to
update according to the numbers I put in for 2008 ...

I want to create a workbook which reads the value from a particular named
range (Test) in a number of workbooks.
The actual formula is:
='Y:\Testing\TestSource001.xls'!Test

Sorry, this was posted to the wrong group originally
I can get this info via pivot table, but there has to be a way to get sum it
via a formula.  I have multiple worksheets and each has multiple rows/columns
of data.  I want to use 2 different sets of criteria (from different

hi all again
after sorting 1 problem out i have found that i have another calculation
problem, if anyone can help with a formula please.
Local Time of Starts                                                                         

I have a weird one for you. I am tring to create a fair fielding schedule for
my tee ball team where one child can not sit on the bench more than one a
game and also can not play the outfield possitions twice in a game.
In the ideal world Child 1 would play 1 inning of infield, 1 ...

I need a formula that will count ONLY the number of SKU's that have an
approved date listed in one column and ONLY for "Team A" in another column. I
need this returned on another worksheet. So in my example given below I'd
have only one counted & returned. Does this make sense? ...

I need a formula that will calculate the percentage of assignments completed
(I have supplied the total number of assignments and the number of
assignments for a specific team in a table on my worksheet already) and
return a "Yes" or "No" value if they are 50% or more complete.

Working on Sheet 2, I need to count records from Sheet1 but only want if ColA
= "text1" and ColB = "text2".
COUNTIF(('Sheet1'!A1:A10,"text1")*('Sheet1'!B1:B10,"text2"))
This is the formula I have been playing with that obviously is not working!

I am in a position where I want to reference cells with 11 columns in between
them, i.e. if I first reference Cell A4 I then want to reference Cell M4 and
then Cell Y4 and so on. The first cell would then be Cell =CHAR(65)&4
Obviously you can guess what the problem is, since ...

Hi.  This seems like it should be simple but I'm not having any luck.  If
column A is a list of names and B is a list of corresponding numbers (like
test scores), in C1 I want to find the highest score in B and show the name
of the person to whom it belongs.  I can find the MAX ...