Basicly the spread sheet is a log that we must complete daily. On the sheet we must enter the amount of minutes we work on each project in column C and the code that it falls under in row D (which can be found on the bottom of the page). Then total them all up by code for the day by minutes and enter them in the correct code total box at the bottom of the page. Is there any way to write a formula that will automatically total the minutes for any row that falls under the column C and has the designated code id # (1-7) in column D and place it in the correct totals box at the bottom of the page?
I have been sitting at my desk for 2 days.....Any info would be great...We are not responsible to put the start time and end time...
This message was edited by nickb on 2002-03-14 15:57
I have been sitting at my desk for 2 days.....Any info would be great...We are not responsible to put the start time and end time...
This message was edited by nickb on 2002-03-14 15:57