| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add formula to cells in a column through VB
I have created a form to enter data into a worksheet. Colum 'F' & Column 'H'
are formatted in custom h:mm. In column 'I', I want to put this formula " =SUM((F2+H2)*1440)/60" (I think.) for every record added through the form. Column 'I' is not on the form because columns F & H feed to it. The formula above adds the two times together and converts it to decimal, which is what I need. Thanks, Joel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock a formula to a column of cells | Excel Worksheet Functions | |||
| Sum column of cells that already contain a formula | Excel Discussion (Misc queries) | |||
| Copy formula to a column of cells | Excel Programming | |||
| How to apply a formula to all cells in a column | Excel Worksheet Functions | |||
| Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
Threaded Mode
