Closed Thread
Results 1 to 4 of 4

Calculating Absolute Difference Between Two Time Values

  1. #1
    markxus
    Guest

    Calculating Absolute Difference Between Two Time Values

    Well I got a problem here guys!!! I am making a spread sheet that will calculate the number of minutes used by a customer... I only got three cell namely start time, endtime then total time used.. My problem is I can't get it right.... I've tried some of the formula given, but still there is something wrong with it... Maybe its because I'm a novice in spreadsheet...
    any suggestion is highly appreciated thanks a lot

  2. #2
    Ghulam Sarwar
    Guest

    business days

    How I do calculate day if our org has 22 days in a month?

  3. #3
    shawn
    Guest

    another formula

    IF(B2>=A2,B2-A2,24-A2+B2)

  4. #4
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    Calculating Absolute Difference Between Two Time Values

    Problem:

    Columns A & B contain pairs of time values from the same day.
    We want to create a formula that always subtracts the earlier time from the later one, regardless of which column each is in.

    Solution:

    Use the IF function as shown in the following formula:
    =IF(B2>=A2,B2-A2,A2-B2)
    Or the ABS function as shown in the following formula:
    =ABS(B2-A2)
    Note: Apply hh:mm format to cells containing the formulas.

Closed 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