+ Reply to Thread
Results 1 to 3 of 3

Get the difference between two time values

  1. #1
    Registered User
    Join Date
    09-18-2018
    Location
    sri lanka
    MS-Off Ver
    2007
    Posts
    15

    Get the difference between two time values

    Dear Friends,

    I have two excel columns which contain "In" and "Out" times of staff members. I want to get the difference between these times. (Out - In)

    A dot (.) has been used instead of colon ( when enter the times. As a result, the format of the available data as like this> i.e. 07.15 for 7:15 AM, 8 for 8:00 AM, 17.3 as 05:30 PM.

    I'm struggling to find a way to do this.

    Can You guys help me?

    Thanks,

    Rasika
    Last edited by RASIKA_99; 10-07-2019 at 12:26 AM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Get the difference between two time values

    Assuming these are hh.mm actual values, then
    1) use the DOLLARDE() function to convert hh.mm to a decimal hour (https://support.office.com/en-us/art...d-a38476693427 ) =DOLLARDE(value,60)
    2) perform the subtraction =DOLLARDE(value1,60)-DOLLARDE(value2,60)
    3) then use DOLLARFR() to convert back to hh.mm if desired (https://support.office.com/en-us/art...4-3042c5d4f495 ). =DOLLARFR(DOLLARDE(...)-DOLLARDE(...),60)

    Will something like that work for you?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    09-18-2018
    Location
    sri lanka
    MS-Off Ver
    2007
    Posts
    15

    Re: Get the difference between two time values

    Thanks friend. It works perfectly .

    Rasika

+ 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. [SOLVED] How to sum values/time difference as they switch between positive & negative
    By watkincm in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-23-2015, 09:24 PM
  2. [SOLVED] Time Values Difference
    By Firepxy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-05-2013, 02:09 AM
  3. difference in milliseconds between time values
    By aocana in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-11-2013, 05:23 AM
  4. Replies: 7
    Last Post: 04-13-2012, 08:21 PM
  5. difference in milliseconds between time values
    By bigbillis in forum Excel General
    Replies: 3
    Last Post: 12-30-2010, 01:34 PM
  6. [SOLVED] Calculating Absolute Difference Between Two Time Values
    By markxus in forum Tips and Tutorials
    Replies: 3
    Last Post: 08-10-2005, 01:43 AM
  7. Replies: 1
    Last Post: 03-25-2005, 01:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1