How do I write the formula to calculate the difference between two times? In other words, I want to create a formula (in Excel) that will automatically tell...

Hello, I hope I can explain what I'm looking for. Is it possible to link a formula to another sheet?? I'm trying to use a similiar formula to the "If"...

normally, if i select 2 or more cells that have numbers in them, i can see the sum at the bottom right of my screen,i can't see this now. does anyone know how...

Auto filter does pretty much everything I need apart from filtering by month. Col A contains dd/mm/yy type dates, and at the moment I have the date repeated in...

What would be the correct formula for counting time up to but not beyond a certain point? Example: From 22:00 up to but not past 22:58. Thank you

in page setup, i have "gridline" checked and i can also see the gridlines in page preview. However, the gridlines are not appearing on the paper when the...

Have a data table consisting of 36 columns and rows that vary in quantity from 13000 to 19000 rows. From this table, there are 3 pivot tables to give you the...

I need two different kinds of date calculations. 1. I need to be able to show what age someone is today. Date of Birth is a field, but they want to show...

Hi Guys I am using a user defined function that I wrote in the code of the workbook, and it works fine. Except for the fact that when I change data on the...

I have several sheets in a workbook and I would like to number the pages in each worksheet. How Can I do this. In other words, sheet 1, sheet 2 and sheet 3...

I work with Excel several hours every day. The default number formatting ("General") is not one that I EVER use. But I can't see a way to change the default...

Formual being used is as basic at it gets. +f2+h2+j2+l2+n2+p2 2 5 6 7 8 Condition: Spreadsheets are being received from a wide range of sources. In...

How do I print a worksheet that shows the formulas contained within?

Excel Newsgroup: I have a Workbook with several hidden columns. I am trying to selectively unhide them. Following the Help directions I cannot do it. I can...

Hi: Am in need of a formula to determine the average of many military TOD (Time Of Day) entries. These cells are in text format and are expressed as military...

when I email my coworkers with an excel attachments, they don't get the same format the same way I do. I always save my spreadsheet before sending emails. ...

Hi Sandi: Something like: Sheet1.Hyperlinks.Delete should work. Regards,

How would I count cells within specific date ranges? For example, if I have a column of cells that have different dates in them, how would I count the number...

Hi all, new to forum and found it by being totally stuck :P Basically, I've got some information for example: (A) (B) (C) Date ...

Hi, I have a large excel data worksheet which has this basic look: Item: PointA PointB PointC PointD PointE #01 01-Feb 04-Feb 05-Feb ...