Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Up A formula For A Time Sheet
I have setup a column with a list box that includes several project headings.
I have also setup a list box that allows you to select the amount of time you spend on each project. The worksheet has 30 rows that will allow you to select the project and time, what formula can I use that will allow me calculate the time spent on each projects as a whole. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Up A formula For A Time Sheet
=SUMIF(A:A,"Project 1",B:B)
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "zooming" wrote in message ... I have setup a column with a list box that includes several project headings. I have also setup a list box that allows you to select the amount of time you spend on each project. The worksheet has 30 rows that will allow you to select the project and time, what formula can I use that will allow me calculate the time spent on each projects as a whole. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Up A formula For A Time Sheet
Bob
Thanks for the formula, it worked fine, however when I attempt to copty the formula into another sheet of the workbook the formula retains the previous sheets references. How can I resolve this? Thanks Michael "Bob Phillips" wrote: =SUMIF(A:A,"Project 1",B:B) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "zooming" wrote in message ... I have setup a column with a list box that includes several project headings. I have also setup a list box that allows you to select the amount of time you spend on each project. The worksheet has 30 rows that will allow you to select the project and time, what formula can I use that will allow me calculate the time spent on each projects as a whole. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Up A formula For A Time Sheet
What do you mean exactly?
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "zooming" wrote in message ... Bob Thanks for the formula, it worked fine, however when I attempt to copty the formula into another sheet of the workbook the formula retains the previous sheets references. How can I resolve this? Thanks Michael "Bob Phillips" wrote: =SUMIF(A:A,"Project 1",B:B) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "zooming" wrote in message ... I have setup a column with a list box that includes several project headings. I have also setup a list box that allows you to select the amount of time you spend on each project. The worksheet has 30 rows that will allow you to select the project and time, what formula can I use that will allow me calculate the time spent on each projects as a whole. Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Up A formula For A Time Sheet
Bob
It's OK, I sorted it Thanks anyway Michael "Bob Phillips" wrote: What do you mean exactly? -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "zooming" wrote in message ... Bob Thanks for the formula, it worked fine, however when I attempt to copty the formula into another sheet of the workbook the formula retains the previous sheets references. How can I resolve this? Thanks Michael "Bob Phillips" wrote: =SUMIF(A:A,"Project 1",B:B) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "zooming" wrote in message ... I have setup a column with a list box that includes several project headings. I have also setup a list box that allows you to select the amount of time you spend on each project. The worksheet has 30 rows that will allow you to select the project and time, what formula can I use that will allow me calculate the time spent on each projects as a whole. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Excel formula for a time sheet | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) |