How to totalize hours, even when the sum > 24?
I do have to cells formatted hh:mm.
Bart

I have to enter tons of dates into Excel. Currently I am using the
Date-Format for the Cells in the format DD.MM.YYYY
As I use the numeric block of the keyboard, it would be very much
easier to just enter DDMMYYYY instead, since I have to move the hand

I have a workbook with two worksheets. the first sheet is a test, with a
macro at the end. When the macro is clicked a new row is generated at the top
of the second worksheet and information about the test taker is pasted on to
this row. This gives me a log of all who take the ...

I have the following formula in cell B2:
=(A2 *(2-B1)/1000)*T2+S2
When I drag this formula to Cell C2 I would like for it to appear like:
=(A2 *(2-C1)/1000)*T2+S2

In Excel 2007, if I type the string ACN, it is automatically changed
to CAN.
I dont want that to happen and dont know how to turn that off.  I
tried turning off auto-entry but that didnt work.  I tried entering

Is there any way to set Excel so that a backup is made of the file you are
working on each time you save? I have made a cursory study of the
autorecover feature of the program and still do not fully understand this
feature. I do not believe it does what I have in mind. Any ...

I got a excel sheet in which I saw a figure like combo box of control
toolbar. but it is not. when I right click it . the cell reference box( LHS
of worksheet top where cell reference is there) reads as drop down1031.
This figure has a month drop down list, referenced from ...

Hi
I am trying to find a code that will allow me to find a maximum value in a
column (say column B) and then finds the corresponding value in the same row
in column A.

I'm trying to create a IF statement in a cell that will show the following
results:-
If cell A1 is between
0-520 display "Option 1"

I have a problem.
My data in row 3 starts from different cells all the time,i.e.,
sometimes from g3, fg3, etc.
i have some data in row 4 (the number os values here is also

Newbie here.
I would like to add an autopopulation script when activated to present
options with checkboxes or the like, for comments and to create a final
comment from the options selected for pasting.

Setting up a tabulation speadsheet,has 40 rows and 10 columns.Question is
when I do my formula which is a subtraction for each column,I want to use a
refernce # from the first row of each column =Sum(F1-D3)=SUM (G1-D3)and so
to=Sum(P1-D3)Rather than enter each manually,because ...

I am trying to create a macro that will select several columns on a
page and hide them.  Thus far I have the following code:
Sub Macro1()
'

I have a table with locations along a hiking trail. Another column
shows the mile posts. I want use a third column to place a sequential
number in the same row as the location and mile post where I camp each
night.  The table looks like this:

I have a column of stock prices in column B with associated dates in column
A.
Let's call it dates in A1:A100 and prices in B1:B100.
In cells A101:A200 I repeat the same dates