empty cell in formula

  • Thread starter Thread starter TS Mathews
  • Start date Start date
T

TS Mathews

I have an Excel book but it's for advanced users and, I guess, this is so
basic that the answer is not there.

I have a really simple spreadsheet I use to replicate my time cards from
work. for this example I have:


1 2 3
A report time start time stop time

Sometimes there is a report time which is earlier than the actual work start
time and sometime not.


The difference between report time and start time is shown later as "stand
by." I add the stand by time to the difference between start and stop time
to get the total hours of work for a given time period. If there's no
report time, I get an error and, thus, always have to enter the same time as
the start time to make the formula work. Is there some way to have the
formula take A1 if there's something there and ignore it if not?

Hope that's clear...thanks for any help.
 
I'm not sure of your equation, but why not use something like ISBLANK(A1) to
check for blanks in the report time.

HTH,
Barb Reinhardt
 
Back
Top