Formating Cells

[Simon]

I am creating a timesheet, In the total hours worked
column I have formulas to count time worked that day. I
want to hide the value (0:00) until start and finish times
have been input for that day.

Can Anyone Help!!!

 

[Frank Kabel]

Hi Simon
if you enter the starting and ending time in A1, B1 enter the following
in C1
=IF(AND(A1<>"",B1<>""),B1-A1,"")

 

[Ian Coates]

The easiest way in Tools-Options-View and uncheck the Zero values box.

Ian

 

[Norman Harker]

Hi Simon!

The general elapsed time formula is:

=B1-A1+(B1<A1)

We use the +(B1<A1) to cover cases where clocked in times span
Midnight.

To make this formula return "" pending entries in both A1 and B1

=IF(COUNTA(A1:B1)<2,"",B1-A1+(B1<A1))

COUNTA only counts cell with values in them and will be 2 when both
cells are completed.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.