Time Sheet
=IF(SUM(D4:D8)=0,"",SUM(D4:D8))
"Yogi_Bear_2k2" wrote:
Hi Guys!! Newbie Here! Please can youy try and help me out with a litle
problem regarding my Time Sheet? What I want is a formula (if possible (no
pun intended))
to be able to ad up all my hours worked in total (cells d4 to d8.) This is
simple to do I know using the SUM function, BUT, what I want to be able to do
is if the total number of hours worked is zero then leave the total box blank
(and not have a 0 in it.) Hope this makes sense!! Thank guys!!
--
Yogi
|