Results 1 to 3 of 3

Calculate Date with Time Difference

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    87

    Calculate Date with Time Difference

    Attached a screen shot that shows what the application is displaying the date and time value
    with time remaining

    I need to create a formula that would confirm what the application is displaying

    Example

    Start the Job on 08-30-2011 8:01:00am
    Due date 08-302011 11:59am
    SLA Remaining 4H

    If I plug in the same figures, i need to confirm that is is True 4H

    and if it past due like the attached screen shot, my formula should confirm same numbers.

    Thanks
    Attached Images Attached Images
    Oceans Blue

Thread Information

Users Browsing this Thread

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

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