| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SORTING BY COLUNM ENTRY | Excel Discussion (Misc queries) | |||
| Spread few colunm data across single page. | Excel Discussion (Misc queries) | |||
| If I have a colunm of numbers, can I format to highlite the smalle | Excel Discussion (Misc queries) | |||
| How to keep colunm headings when scrolling down in excel | Excel Discussion (Misc queries) | |||
| Permanently visible colunm in an Excel chart | Excel Discussion (Misc queries) | |||
Hybrid Mode
