Results 1 to 2 of 2

Thread: logging in spreadsheet help

  1. #1

    Exclamation logging in spreadsheet help

    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi all please help,

    i have a logging in spread sheet form members of staff but what i want to know is:

    if cell b2 has 08:15 and cell c2 is blank because they forgot to log out how can i put a formula in c2 to put a default time of of 15 mins in so c2 shows 08:30

    can this be done.

    thanks in advance

  2. #2
    If I'm understanding your request correctly, you're asking for something like (If C2=blank, C2=B2+0:15). I don't believe this is possible because of circular logic; C2 would reference itself. The formula you'd want is =IF(C2="",B2+"0:15"), but it would need to be in another column, say an error checking column.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts