Hi Garry,
Am Thu, 24 Apr 2014 21:01:20 -0400 schrieb GS:
Ok.., the only issue I have found thus far is that this formula
doesn't work if I overwrite ElapsedTime with a constant value in
place of entering start/stop times. My purpose for this is to
permit using 'flat rate' for time as opposed to 'straight time'
spent.
that is because of the IF statement at start. If Start time = "" then
output = "". Change the start time to the elapsed time that means
change F3 to H3:
=IF(OR(AND(MONTH(ThisDate)=MONTH(NextDate),NextDat e<""),H3=""),"",SUMPRODUCT(--(MONTH(C$3:C3)=MONTH(C3)),--($D$3:D3=D3),$H$3:H3))
I already figured that out! It works as expected when the ref is
ElapsedTime instead of Start! Thanks for confirming...
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion