I can use the IF function in pivot table calculations if I my logical test is
based off the DATA being summed, however, if I try to use a field in the ROW
section of the pivot table, it does not work.  For example, if I want to test
a field called "States" for any Florida results ...

for example if a employee logs in at 5.00pm in the evening and logs out at
3.30am, how to calculate the no.of hours between 5.00pm and 3.30am, (date is
not captured)

I have 10 workbooks. Each has its own sheet/tab called CYR, and each has its
own tab called Load. In each file's Load tab, there is the same formula in
cell M1
 ABS(CYR!J3)/Z1

I have realised that you can't add conditional formatting to sheet1 that
references data from from sheet 2, so I am displaying the data from sheet 2
onto sheet 1 which I will hide when completed, I can set conditional
formating using the data but it doesnt seem to work, is it ...

I am trying to print a legal sized document but in the print preview, it
shows up only in letter sized format.  I changed the document size in the
printer to legal and everything else in the setup to legal.  The preview uses
a legal sized background but my document is cropped to ...

I have an excel workbook which has various reports created (using excel
formulae across different worksheets) based on master data which I maintain
in the first sheet.
If the master data is entered (or pasted manually) into the first sheet,

I want to sum all cells in the range b69:b87 if the corresponded date
on A69:A87 greater then today (22-June-07)
below is data on cells A69:B87 on cell B88 i enetered
=SUMIF(A69:A87,">today()",B69:B87) and received 0 - what wrong?

I am trying to transfer a cell value and paste it on 24 rows on
another worksheet. The next day I take another cell value and paste it
on the next 24 rows on the other worksheet. Automatically, is the
intention. I have a sheet with 40000 rows and need to transfer the

I'm attempting to create a spreadsheet to log my jog distances, and times.  
I'm wanting to be able to type in the time in a standard format (i.e. 17:38 =
17 minutes and 38 seconds), and be able to take that value from the cell
17:38 and display a pace in minutes/mile of the same ...

I have received an Excel workbook - most gridlines are visible, but some of
these not. Any ideas about the cause and how to turn all gridlines visible?
Many thanks,
Koen

In a cell I have a line of ticks, how do I count them?

I need help with a "simple" formula in a basic spreadsheet.  I have the
months of the year in one column, and a dollar amount in the next column.
Question:  If I fill in a number in Jan, Feb, Mar, & April, and fill in
zero's for the rest of the months, what would the formula be to ...

I have a worksheet that has 100 tables consisting of dates and injection
rates.  The tables do not all start on the same date, but I need to have
totals for each date and I'm not sure how to do this.  I've tried a couple
things but nothing is working.  My worksheet looks like ...

I appologise if this has been covered before, or that it is really basic.  I
am new to Excel and new to this forum!!
Here it is:
After I have pasted large volumes of text (say 2 or 3 paragraphs) in to a

I have a schedule with each project listed and all resources assigned to each
project by area of expertise (AOE).  The top of the schedule represents the
weeks of the year by dates (rows 7 and 8).  I assign a start date and end
date next to each resource in columns G and H, ...