Results 1 to 3 of 3

Hours a staff member works each day formula returning unexpected result

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-20-2009
    Location
    Plymouth, England
    MS-Off Ver
    Excel 2013
    Posts
    149

    Hours a staff member works each day formula returning unexpected result

    Hi all,

    I'm working on a work rota.

    I have written a formula which works out how many additional hours a staff member works each day. However in some circumstances the formula is returning a negative result when I'm expecting a 0 return.

    I've attached the file with notes. Apologies for my untidy formulas in advance!

    Many thanks,

    Luke
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] A formula to work out hours on a staff rota
    By bigtiger1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2013, 07:23 PM
  2. [SOLVED] Long variable returning unexpected result which appears to be only integer value
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-05-2013, 10:59 AM
  3. SUBSTITUTE formula giving unexpected result
    By gkeller81 in forum Excel General
    Replies: 15
    Last Post: 06-04-2012, 01:16 PM
  4. Cell formula result unexpected when blank date criteria entered
    By TGP in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-06-2010, 07:59 AM
  5. Replies: 1
    Last Post: 07-06-2009, 07:07 PM

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