I'm trying to test a cell D5 which contains a time eg '07:00' to see if falls
within a time range or is blank or to print it if it is within range. Excel
indicates an error???
=if(or(D5, 06:30, D5>8:00), "CHECK TIME" , D5)

I have this monsterous spreadsheet and 5 summary pages. I want to hide the
tabs with the back up information AND associate the hidden tabs with their
summary page.  I thought I could do this, but cannot figure it out. Anyone
know if this is possible or how to ??? Please. :)

I use an Excel file as source file to create WORD mail merged documents in a
table format where users need to complete some blanks.  The mail merged WORD
file is then cut up to unique files and sent to different users to fill in
reqeusted data.  The objective is to transfer the ...

I have 1 tab, called 'Annual stats',within which there are 9 cells which
need formulas to add the values from the other 52 tabs (weeks). Each tab for
the weeks are the same, so cell E30 is for example one cell which I need to
be added. The tabs are labelled 'Week1' 'Week2' etc.

I am curently send worksheets from within a woorkbook however I am gettign
the email warning screen for every worksheet how can I remove this message or
hust have it come up once as 15 times is quite frustrating.
Thanks

=SUMPRODUCT((A5:A504="Permanent")*AY5:AY504)
Colmun A cells can either be blank or hold data in sets of 4 rows i.e.
a1 will be "=con1"
a2 will be either "Permanent", Associate or Contractor

Hi, I am offer Data Conversion Service offers flexibility,
responsibility and ability to cater to any new process. If you have a
data conversion requirement or want to convert bulk documents than
take advantage of conversion services. That enables you to handle

I am trying to apply a conditional format to a range of cells containing a
version of this formula.
=IF(H16=0,"N/A",(H16-J16)*100/J16)
If the cell value is greater than 2, I need the format to change. However,

I have a pivot table with three fields of data that are totaled by
Product Line. I need the Total Data fields which are listed as rows to
be listed as columns, how do I swop them?
Can anybody help.

Is there a utility or a way to save an excel 2007 spreadsheet as a .wk1 file
if I do not have excel 2003 or a previous version?

I am working in excel and need to import into Sage.  I can create the CSV
file that is required but I lose the leading zeros from certain text
columns/fields when I convert to from excel to CSV (for example 025 becomes
25).  How can I overcome this.  If I edit the CSV file in ...

Does anybody know if it is possible to change the colour and or contrast of
the cell selection highlight colour.  This is where you wish to highlight
cells but not change thier colours in the spreadsheet.   The highlight colour
contrast I am seeing on screen is too light.  It ...

Can  any body think of a formula if i want to sum up each collection as
follow, because i have a lot of collection cell i have to calculate.
A              5000
B              2000

Hi to all the much-smarter-people than me out there!!
I've got a spreadsheet that I want to automatically insert names into a
sheet based on different shifts they work.  It looks like this
#    Name    Surname    Monday    Tuesday

Hi! I have a worksheet with an autofilter. I would like to turn of the
possibility to sort by descending and ascending, and just sort on the entrys
below the header. Is there a way? (I use excel 2003)
Would really appreciate the help!