Results 1 to 3 of 3

Formula calculating Time is not working if any input cells remain blank.

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2011
    Location
    Orlando, Florida
    MS-Off Ver
    Excel 2010
    Posts
    6

    Formula calculating Time is not working if any input cells remain blank.

    I have created a excle spreadsheet using 6 data entry cells to record the time in or out. I want to give the option of six in and outs and when each of these cells are used the time calculation formula works fine however if the employee only needs to use 2 or 4 of the input cells then my time calculation formula is not working. I don't know if it makes a difference or not but the input cells are data validated and are conditional upon the preceeding entry.

    Julie
    Last edited by excel1z008339; 12-21-2011 at 03:46 PM. Reason: Solved

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1