Results 1 to 16 of 16

[SOLVED]Time/Date calculation to check response time

Threaded View

  1. 08-23-2013, 03:29 PM #1
    tailz
    tailz is offline
    Registered User
    Join Date
    08-20-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2007
    Posts
    30

    [SOLVED]Time/Date calculation to check response time

    Hi,

    I have a spreadsheet which includes,

    Callout Date
    Callout Time
    Arrival Date
    Arrival Time

    I need to calculate the time between callout and arrival to see if a response time was met. The working hours are 9 - 5 Monday to Friday and the response time is 4 hours, so looking at the attached sheet, the bottom entry has an arrival date the following day from the callout date. Can anyone help out with a formula please?

    Many thanks

    Tony
    Attached Files Attached Files
    Last edited by tailz; 09-01-2013 at 10:21 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculation of time difference between the Start date & time & End Date & time
    By Harry Jones in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-17-2012, 03:54 PM
  2. Date and Time Calculation
    By tskurth in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2008, 07:59 PM
  3. [SOLVED] Calculating days & time left from start date/time to end date/time
    By marie in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2005, 10:40 AM
  4. [SOLVED] Ignoring Time in a Date Time Calculation
    By nmp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2005, 04:35 PM
  5. [SOLVED] time/date calculation
    By bladelock in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2005, 09:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1