Hey All,
I am trying to find out how to make an equation for an entire column.
Here is my current scenario:
I have a column for time in, and I have a column for time out. I would like to have a column for total hours worked for each day that will take the difference of time in from time out. I know how to do this for each individual row(=D4-C4), but I would like to set it up so that the column automatically does it.
Thank You.
2007-12-18 02:21:26 · 6 answers · asked by mark m 2 in Computers & Internet ➔ Software
Put your formula in the first cell of the column, then click it and drag down to highlight the cells you want to have the formula in and press Ctrl+D - this will Fill Down the column with the formula - but it will be modfied to refer to the correct cells.
ie first cell c1-d1
c2-d2
c3-d3 etc
2007-12-18 02:31:59 · answer #1 · answered by mazdaman 4 · 0⤊ 0⤋
That would take huge amounts of processing and storage needs to do. Stick with the needed cells, say 500.
To add the values to all the cells enter the formula in the top row, select that cell and press control-c to copy, then hold down shift, scroll to the bottom cell and select it. This would select all the cells between the top and bottom. Then press paste the values in.
You can also place the first cells values in the clipboard and select the column and past it into the entire column if you wanted to.
2007-12-18 02:40:11 · answer #2 · answered by Bumblebee 4 · 0⤊ 0⤋
Calculate it for for first row using the formula(=d4-c4) and then selecting the whole column of time in & time out press sigma and u have the whole column for total hours worked.
2007-12-18 02:32:08 · answer #3 · answered by panda ki haveli 1 · 0⤊ 0⤋
Hi
What you are looking for is an array formula. The procedure for entering an array formula is in Excel's help. Just search for
array formula
in Excel's help. The exact steps to take are different for different versions of Excel, so I can't post an answer that covers all the versions.
-Jim Gordon
Microsoft Mac MVP
MVPs are independent and do not work for Microsoft
http://mvp.support.microsoft.com/
2007-12-18 13:49:41 · answer #4 · answered by jimgmacmvp 7 · 0⤊ 0⤋
make life simple
rearrange your spreadsheet
let column C be time in
let column D be time out
then in E2 write the formula =(D2-C2)
now you can copy the formula
Edit->Copy
and paste it into as many cells in column E as you like.
2007-12-18 02:36:59 · answer #5 · answered by In My Neighborhood 4 · 0⤊ 0⤋
just click on a cell with that formula, than click and drag that little black square on the bottom-right corner of the highlight.
2007-12-18 02:28:36 · answer #6 · answered by Silver Fox 3 · 0⤊ 0⤋