Time Sheet

[Guest]

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!!

 

[Guest]

=IF(SUM(D48)=0,"",SUM(D48))

 

[Guest]

Yogi

Or you could do your sum formula and goto Tools/Options/View/ uncheck zero
values. This will cause all zeros to not be shown.

HTH

Mike Rogers

 

[Guest]

Are you using hours in time format? If so you could just custom format the
sum cell as

[h]:mm;;

 

[Guest]

Thank you very much!! Your great!!
--
Yogi

=IF(SUM(D48)=0,"",SUM(D48))