adding same format for colunm
 

Thanks for those that helped me with my last time question. Would of replied
back on my original post but can't find it now. Anyway, the question now is.
How do i format a colunm for the time formula. =D2-D1 + (D2<D1). I have 35
more cells to do. Can it be done without doing each cell one at a time?

adding same format for colunm
 

Hi
Try dragging the formula down or across.
Thanks
Matt



doss04 wrote:
Thanks for those that helped me with my last time question. Would of replied
back on my original post but can't find it now. Anyway, the question now is.
How do i format a colunm for the time formula. =D2-D1 + (D2<D1). I have 35
more cells to do. Can it be done without doing each cell one at a time?

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200810/1

adding same format for colunm
 

Thanks.
I guess i should tell you. I'm very new to excel. Self teaching.
I just tried that. It didn't work. I'll explain what i'm doing.

col C col D col E
ARR CLR TOTAL
I've formatted the columns properly to hh:mm. I'm putting the formula in
column E. When i try and drag the formula. it only changes the C&D columns
not the E column, if i'm making sense.

"Mattlynn via OfficeKB.com" wrote:

Hi
Try dragging the formula down or across.
Thanks
Matt



doss04 wrote:
Thanks for those that helped me with my last time question. Would of replied
back on my original post but can't find it now. Anyway, the question now is.
How do i format a colunm for the time formula. =D2-D1 + (D2<D1). I have 35
more cells to do. Can it be done without doing each cell one at a time?

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200810/1

adding same format for colunm
 

Do you want a running total in Column E?

How about =D1-C1 in E1

Then =E1 + (D2-C2) in E2

Copy that down.

Assumes your formula below is a misprint and you have intime in column C and
outtime in column D.

If you just want the difference for each row.

=D1-C1 in E1.......................copy down.


Gord Dibben MS Excel MVP



On Mon, 6 Oct 2008 00:08:00 -0700, doss04
wrote:

Thanks.
I guess i should tell you. I'm very new to excel. Self teaching.
I just tried that. It didn't work. I'll explain what i'm doing.

col C col D col E
ARR CLR TOTAL
I've formatted the columns properly to hh:mm. I'm putting the formula in
column E. When i try and drag the formula. it only changes the C&D columns
not the E column, if i'm making sense.

"Mattlynn via OfficeKB.com" wrote:

Hi
Try dragging the formula down or across.
Thanks
Matt



doss04 wrote:
Thanks for those that helped me with my last time question. Would of replied
back on my original post but can't find it now. Anyway, the question now is.
How do i format a colunm for the time formula. =D2-D1 + (D2<D1). I have 35
more cells to do. Can it be done without doing each cell one at a time?

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200810/1