I've got a spreadsheet with a number of columns and I could do with putting a
subtotal into a column in the middle of the data. Currently the columns are:
Charged - Location - Size - Item
Every line in my source data has a value in the Size column which is the

I am trying to create a 24-hour staffing schedule but I cannot figure out how
to automate the process.
There are 7 overlapping 12-hour shifts with two work groups A & B.  A works
3 12 hour days with 4 off then works 4 12-hour days with 3 days off.  B works

i am very very new to excel and i have created a report that has some
formulas in it..everything looks good. so i print it.
when i reopen the report a box comes up and has three little square that say
 Update....Dont Update...Cancel....doesnt matter if i pick dont update or

Not sure if I worded that correctly. Here's what I need to do: I have sales
data for a month that is listed individually by date and item number. I need
to go through the entire workbook and find each occurance of each item and
add together the number of items ordered. Here is an ...

I need an automatic formula or a format that give's me the ability to enter
these numbers (Handling Time) as (HH:MM)
but to be converted to fractions (example:  00:30 should be displayed as
0.50, as 00:30 is 50% of an hour)

How do I check if the content in a cell, when divided by 4, returns an
integer? It should give me 150 if it is an integer and display "NA" if it is
not an integer.
For example, the formula should check if the content A2 divided by 4 is an

Office97 - Excel97 - XP SP2
I did something to make my .xls files disappear.
They're all there.
I can see them with Explorer.

I have a excel file a fairly large database in one sheet and another sheet
for pivot tables from that databse. once the pivot tables  are loaded the
capacity jumps from a mere 175 or 200 kb to 9 or 10 mb. and gives me
difficulties in saving the file in network drives. how can i ...

I need an automatic formula or a format that give's me the ability to enter
these numbers (Handling Time) as (HH:MM)
but to be converted to fractions (example:  00:30 should be displayed as
0.50, as 00:30 is 50% of an hour)

I have a roster that goes across 8 weeks .
Each line (Say Line 2) corresponds to the number of hours in that week -
being line 2 that a person works . Line 2 is 44 hours, Line 5 may be 36 hours
etc etc.

I'm a total newbie to Excel (and without a manual), and my boss has asked me
to generate commission reports based on an Excel worksheet.  Can any one tell
me how to generate reports?  I have Excel 20002.

I'm a a co-worker sending me spreadsheets that are created in alother
program and saved as Excel files. I have no problem opening these in MS
Excel 2003 or 2007, but I do get a message that says the file is in a
different format than specified by the file extension but it opens ...

I recorded a macro to input a number, move right 3 spaces, enter a number,
ect .......
when I recorded it I intended to go back and replace the numbers I put in to
record with whatever I need like a question mark.  Here is the macro as it is

Is there a formula to calculate failure rates in excel?  I have a life
expectancy, age of equipment, and failures in a year and would like to have
a formula to determine failure rate.  Thanks in advance!
Frank