Results 1 to 10 of 10

Working out times over midnight with a twist

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2017
    Location
    Northern Ireland
    MS-Off Ver
    Various
    Posts
    28

    Working out times over midnight with a twist

    We have A1 (Requested time) B1 (Allocated) time C1 (Started time) D1 (Completed time)

    I am looking to report on two things (time taken to allocate a job, relative to the requested time) & Time taken from start to complete of the job.

    I am using =MOD(B1-A3,1) so that any jobs requested/started before midnight and allocated/completed after midnight still give a value.

    However we sometimes allocate a job before the requested time (usually just a few minutes).

    Is there any way i can work my formula to provide a zero value if the requested time after the allocated time?
    Last edited by Custhasno; 01-27-2018 at 10:23 AM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Average of Times Spanning Midnight
    By LJenny in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-24-2015, 10:44 AM
  2. [SOLVED] Difference between two times - avoiding ###### for times that span midnight
    By Abarency in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-07-2015, 01:15 PM
  3. Trying to calculate +/- min for actual times before and after midnight
    By WTFCanucks in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-11-2014, 12:08 PM
  4. Graphing completion times across midnight
    By wrudiger in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-28-2013, 03:18 PM
  5. difference between times not working for after midnight.
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-28-2013, 01:47 AM
  6. Median of Two Times Over Midnight
    By melissaallen5 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-11-2012, 12:56 AM
  7. Times and midnight issues
    By bslob in forum Excel General
    Replies: 1
    Last Post: 12-08-2007, 01:36 AM

Tags for this Thread

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