Formating Cells

  • Thread starter Thread starter Simon
  • Start date Start date
S

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!!!
 
Hi Simon
if you enter the starting and ending time in A1, B1 enter the following
in C1
=IF(AND(A1<>"",B1<>""),B1-A1,"")
 
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.
 
Back
Top