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?
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.aspx/excel-new/200810/1
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.aspx/excel-new/200810/1 > >
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.aspx/excel-new/200810/1 >> >>
