software

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 quot;=SUM((D12-C12)*24,(F12-E12)*24,(H12-G12)*24)quot;.
Column J calculates cost using the formula quot;=I12*B12quot; 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 quot;0.00quot; and quot;$0.00.quot;

Hi Ellen

Menu Bar, Tools, Options, View Tab. Unckeck box quot;Zero Valuesquot;.

PB

quot;Ellenquot; wrote:

gt; I am working on a timesheet that add time and calculates cost. The formula I
gt; am using for column I of the timesheet (which can be used for up to three
gt; in/out times per day) is quot;=SUM((D12-C12)*24,(F12-E12)*24,(H12-G12)*24)quot;.
gt; Column J calculates cost using the formula quot;=I12*B12quot; where column B is the
gt; hourly fee.
gt;
gt; My question is, how can I get columns I and J to be blank until they are
gt; needed. Right now they fill with quot;0.00quot; and quot;$0.00.quot;

First of all, you don't really need sum. And the way that many people get
rid of unwanted 0 values that are the results of formulas is to wrap the
formula in an IF statement that checks whether the formula will result in a
0. For instance, the following formula should work for you:

=IF(COUNT(C12:H12)gt;0,(D12-C12)*24 (F12-E12)*24 (H12-G12)*24,quot;quot;)
Assuming that the numbers in the range C12:H12 will be numeric, this formula
worked for me. And then for the other formula:
=IF(I12lt;gt;quot;quot;,I12*B12,quot;quot;)

You could use SUM if you want, and just wrap it in something similar. For
instance you could say =if(sum(...) = 0,quot;quot;, sum(...)

HTH
--
Kevin Vaughnquot;Ellenquot; wrote:

gt; I am working on a timesheet that add time and calculates cost. The formula I
gt; am using for column I of the timesheet (which can be used for up to three
gt; in/out times per day) is quot;=SUM((D12-C12)*24,(F12-E12)*24,(H12-G12)*24)quot;.
gt; Column J calculates cost using the formula quot;=I12*B12quot; where column B is the
gt; hourly fee.
gt;
gt; My question is, how can I get columns I and J to be blank until they are
gt; needed. Right now they fill with quot;0.00quot; and quot;$0.00.quot;

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

quot;Pancake Batterquot; gt; wrote in message
news
gt; Hi Ellen
gt;
gt; Menu Bar, Tools, Options, View Tab. Unckeck box quot;Zero Valuesquot;.
gt;
gt; PB
gt;
gt; quot;Ellenquot; wrote:
gt;
gt;gt; I am working on a timesheet that add time and calculates cost. The
gt;gt; formula I
gt;gt; am using for column I of the timesheet (which can be used for up to three
gt;gt; in/out times per day) is quot;=SUM((D12-C12)*24,(F12-E12)*24,(H12-G12)*24)quot;.
gt;gt; Column J calculates cost using the formula quot;=I12*B12quot; where column B is
gt;gt; the
gt;gt; hourly fee.
gt;gt;
gt;gt; My question is, how can I get columns I and J to be blank until they are
gt;gt; needed. Right now they fill with quot;0.00quot; and quot;$0.00.quot;
gt; 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. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;Rogerquot; gt; wrote in message
...
gt; Hello PB
gt;
gt; On this subject, I have the 'Zero Values' unchecked, but would like to
gt; also hide the dashes (-) a zero balance still displays. Can I do this?
gt;
gt; Thanks
gt;
gt; Roger
gt;
gt; quot;Pancake Batterquot; gt; wrote in
gt; message news
gt;gt; Hi Ellen
gt;gt;
gt;gt; Menu Bar, Tools, Options, View Tab. Unckeck box quot;Zero Valuesquot;.
gt;gt;
gt;gt; PB
gt;gt;
gt;gt; quot;Ellenquot; wrote:
gt;gt;
gt;gt;gt; I am working on a timesheet that add time and calculates cost. The
gt;gt;gt; formula I
gt;gt;gt; am using for column I of the timesheet (which can be used for up to
gt;gt;gt; three
gt;gt;gt; in/out times per day) is quot;=SUM((D12-C12)*24,(F12-E12)*24,(H12-G12)*24)quot;.
gt;gt;gt; Column J calculates cost using the formula quot;=I12*B12quot; where column B is
gt;gt;gt; the
gt;gt;gt; hourly fee.
gt;gt;gt;
gt;gt;gt; My question is, how can I get columns I and J to be blank until they are
gt;gt;gt; needed. Right now they fill with quot;0.00quot; and quot;$0.00.quot;
gt;
gt;