+ Reply to Thread
Results 1 to 3 of 3

Calculate Date with Time Difference

  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

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Need to Calculate Date with Time Difference

    You need to explain that calculation. It makes no snese to me, where you get the hours and minutes from.

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

    Re: Need to Calculate Date with Time Difference

    Manual entry

    the result should be the formula to calculate the difference

+ Reply to Thread

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