How do I calculate elapsed time and return the number of hours expressed in hours and tenths of an hour. For example 8:00 AM to 10:15 AM is 2.3 elapsed hours.

Time Result 0 0 5 300 10 52000 30 100 So that when the "result" is at a max, the coressponding time is...

Good day. I am using Excel 2002 on Windows XP Pro. I have a worksheet that I have added a Command Button to. I have printed out the instructions...

I have 3 worksheets, where on one I enter data (numbers), on the second I would average those numbers with the exact formula =AVERAGE('1'!F:F). Now on this...

I'm wanting to build an if then statement, and if the value returns true then return one numeric value, and if it returns false it returns another numeric...

I know how to use countif in a range but what if I want to add text in a big spreadsheet when the text is not in a range so I can total how many supervisors...

i have a drop down box with 3 items say A,B,C then i need the following to operate from that single dropdown box as follows: (if A4=A then A6=D9,B6=D10,C6=D11)...

I use conditional formatting in excel extensively but cannot figure out how to set it to indicate cells that are blank.

In using Excel 2003 I am trying to build a schedule, starting backwards and determining due dates based on timeframes, i.e. 6 months from completion date, 3...

JOB # DOC # for that JOB POPULATED 10300-05-2046 100013224 100013224 10300-05-2046 100013225 ...

Is there a way to use the "value" of a name in a drop-down list to reference a sheet tab name in a formula? A1 has a drop down list. When a name (Bob's...

I am trying to group all the numeric data stored in one column. I know how to sort it but I dont know hot wot Group it. Can anyone help me ?

I have setup a spreadsheet to keep track of my personal bowling scores. I have made everything automatic except 2 formulas that I cannot figure out, can...

I have several columns one is headed TIME and have another column which i would it be an automate entry when i enter the time and the answer would be no if...

Hi, I'm hoping someone could please help me. I have a spreadsheet setup which has on one sheet columns of data that represent data for a particular month. The...

When I open a previously created invoice in Excel, it automatically changes the date of the invoice to todays date. I dont want that, I want to see when I...

Is there no way around this? I have five numbers I want the average for. But they are not always greater than zero. To avoid DIV/0 errors those numbers have...

We are currently using a pocket PC with pocket excel to score a large experiment. It is necessary to record the time of day beside each observation. Obviously...

I am using data in units and dollars by month from this year in an effort to do a quick and dirty sales forecast for next year. I used the units as...

I am having trouble using the forecast function to forecast sales based on history. The numbers I get don't make sense. Can anyone help?