Results 1 to 15 of 15

Counting the number of days overdue based on date and time

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Counting the number of days overdue based on date and time

    I have the following:

    A1 = Date item is due. (DD/MM/YY format)
    A2 = Time the item was delivered (HH:MM:SS format)

    B1 = Actual Date item was delivered.
    B2 = Actual Time item was delivered.

    I'd like C1 to count the number of days the item was late. - taking into account that 16:00:00 is the deadline on each date.

    For example:

    Due Date: 17/06/14 @ 16:00:00

    Arrival Date: 17/06/14 @ 16:01:00

    Days Late = 1
    Due Date: 17/06/14 @ 16:00:00

    Arrival Date: 18/06/14 @ 15:00:00

    Days Late = 1
    Due Date: 17/06/14 @ 16:00:00

    Arrival Date: 18/06/14 @ 16:01:00

    Days Late = 2
    Could anyone help? Thanks
    Last edited by Barking_Mad; 06-19-2014 at 10:14 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting the number of days per month where where a job start time was after 10:00
    By Apache_sim in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-15-2013, 07:59 AM
  2. [SOLVED] Average number of days overdue, between date ranges
    By PJC2013 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-21-2013, 03:01 PM
  3. Convert number of days to specific time & date
    By theperson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2013, 11:44 AM
  4. Counting Days in Date/Time Format
    By ems.payroll in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2008, 04:19 PM
  5. [SOLVED] Counting the number of days between two date
    By Maddoktor in forum Excel General
    Replies: 1
    Last Post: 06-03-2005, 10:05 AM

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