but would like to hide the dashes (-), a zero balance still displays.

One option is to use a custom format that hides zero values. Perhaps
something like this...
0.00;0.00;;

On your formula, one idea would be to factor out the 24...
=24*SUM(D12-C12,F12-E12,H12-G12)

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Roger" wrote in message
...
Hello PB

On this subject, I have the 'Zero Values' unchecked, but would like to
also hide the dashes (-) a zero balance still displays. Can I do this?

Thanks

Roger

"Pancake Batter" wrote in
message ...
Hi Ellen

Menu Bar, Tools, Options, View Tab. Unckeck box "Zero Values".

PB

"Ellen" wrote:

I am working on a timesheet that add time and calculates cost. The
formula I
am using for column I of the timesheet (which can be used for up to
three
in/out times per day) is "=SUM((D12-C12)*24,(F12-E12)*24,(H12-G12)*24)".
Column J calculates cost using the formula "=I12*B12" where column B is
the
hourly fee.

My question is, how can I get columns I and J to be blank until they are
needed. Right now they fill with "0.00" and "$0.00."