G
Guest
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."
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."