Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Functions and Formulas » Time Difference Formula

Time Difference Formula

Previous | Next
Latest post Sun, Feb 7 2010 6:41 AM by Bob Phillips. 1 replies.

  • Sun, Feb 7 2010 12:26 AM

    • Hanz712
    • Not Ranked
    • Joined on Sun, Feb 7 2010
    • Posts 1
    • Points 21

    Time Difference Formula

    Reply |Contact

    I need some help with working out the difference between 2 figures which are based as time figures.

    The data in the spreadsheet I am working on has been just entered in as is and not formatted in time format.

    I.e.

    time a time b time c diff a and b diff b and c total
    12.25 1.2 2      

    I can't seem to work out a formula to work out the differences between a and b, and b and c.

    Can someone please offer some pointers? Am really desperate!

    Thanks

    Hannah

     

     

     

     
    • Post Points: 21

  • Sun, Feb 7 2010 6:41 AM In reply to

    Re: Time Difference Formula

    Reply |Contact |Mark as Answer

    Try this

     

    =TEXT(TIMEVALUE(SUBSTITUTE(TEXT(B2,"00.00"),".",":"))-TIMEVALUE(SUBSTITUTE(TEXT(A2,"00.00"),".",":"))+IF(B2<A2,0.5,0),"hh:mm")

    Regards

    Bob

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.