+ Reply to Thread
Results 1 to 3 of 3

Calculated date difference in hours not equals inserted hours of same value

  1. #1
    Registered User
    Join Date
    08-06-2017
    Location
    France
    MS-Off Ver
    Office for Mac 2011
    Posts
    3

    Calculated date difference in hours not equals inserted hours of same value

    Hello All,

    I am calculating time in "hours:minutes" from difference of dates e.g. CELL A1= 05.08.2017 10:00 CELL B1=05.08.2017 15:30, CELL C1=B1-A1.

    Format A1 - Date, Format B1 - Date, Format C1 - Time [h]:mm .

    As result C1= 5:30 .

    I am writing in to the CELL D1 5:30, same format and value as C1.

    Now in CELL E1 I am using function IF(D1=C1; "ok"; "fault") and I have as result "fault", means C1 not equal D1. In Formula Builder values are the same, but function does not work correctly.

    What is the reason?

    Thank You in advance for any suggestions.

    Best Regards,
    maro12

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Calculated date difference in hours not equals inserted hours of same value

    double posted:https://www.excelforum.com/excel-for...ame-value.html
    Ben Van Johnson

  3. #3
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: Calculated date difference in hours not equals inserted hours of same value

    Quote Originally Posted by protonLeah View Post
    And see my response posted there.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 08-07-2017, 06:25 PM
  2. Date Difference in Hours
    By smugglersblues in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-25-2015, 09:35 AM
  3. [SOLVED] Finding date when the sum in a range equals the hours planned
    By TryToUnderstandExcel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2014, 10:02 AM
  4. [SOLVED] Formula Calculated total work hours - now need to remove breaks and standard hours?
    By smeem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2014, 12:15 AM
  5. Scheduling Data Needed and Bid Hours Calculated for a certain date
    By smirk100 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2013, 06:52 PM
  6. Counting difference between hours if outside of business hours
    By joytech22 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-15-2013, 05:03 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