mike1724
Nov 18, 2009, 12:22 PM
I'm looking for assistance with what I consider a challenging formula. I want to create a
SUMIF (if that is the right function) formula that uses a month from a date to keep track of how much time I worked on a specific project. I have a "date" cell formated 1/23/2009 and an "update time" cell that I enter a number representing an amount of time (1.5 for one and a half hours). Then I have a 12 month cells (October Hours, November Hours, etc.. ) that I want to tally the update time entries with the date as the criteria. Is this possible?
Thanks in advance for any assistance,
Mike
SUMIF (if that is the right function) formula that uses a month from a date to keep track of how much time I worked on a specific project. I have a "date" cell formated 1/23/2009 and an "update time" cell that I enter a number representing an amount of time (1.5 for one and a half hours). Then I have a 12 month cells (October Hours, November Hours, etc.. ) that I want to tally the update time entries with the date as the criteria. Is this possible?
Thanks in advance for any assistance,
Mike