Results 1 to 21 of 21

Problem resolving a MOD formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    MS365 V2308
    Posts
    279

    Problem resolving a MOD formula

    Attached is a file to show what is happening

    Currently I have a Booked time placed in column A followed by a start A and finish A time, then start B finish B time. The 2 times are added together to produce a Total Time loading.
    The formulas in column L, at present only take into account Start & Finish A making the result incorrect againt Column A.
    Can someone help with the correct formulas to be placed in Column L.

    As an example the cell L3 should be N as the completed time in Cell E3 is greater than the booked
    Attached Files Attached Files
    Last edited by ukphoenix; 09-13-2013 at 07:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-02-2013, 02:16 PM
  2. [SOLVED] resolving a #DIV/0! error
    By okcsteve in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2013, 11:14 AM
  3. Need help resolving worksheet naming problem
    By Julez80s in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2013, 03:51 PM
  4. Problem resolving formula with IF function
    By bazhsw in forum Excel General
    Replies: 2
    Last Post: 10-14-2011, 10:27 AM
  5. resolving #VALUE!
    By cwnan64 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-28-2009, 01:11 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