How do i hide cell if the value is zero?

[Steppenwolf]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi, so i have a simple time log in which the end column is to the right the start column, and the start column is filled down such that it equals the end time from the row above. My question is: how do i make it so that if there is no end time in the above row, the start column will not list a bunch of "0:00"'s? Thanks in advance!

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel Hi, so i have a simple time log in which the end column is to the
right the start column, and the start column is filled down such that it
equals the end time from the row above. My question is: how do i make it
so that if there is no end time in the above row, the start column will
not list a bunch of "0:00"'s? Thanks in advance!

You could use a custom number format to format the cell to show a blank
when the value is zero. Or, use a formula something like:
=if(reference=0,"",reference)