Time Sheet

Y

Yogi_Bear_2k2

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

Mike Rogers

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
 
D

daddylonglegs

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

[h]:mm;;
 
Top