+ Reply to Thread
Results 1 to 5 of 5

Difference between time in hours

  1. #1
    Registered User
    Join Date
    12-20-2012
    Location
    UAE
    MS-Off Ver
    Excel 2010
    Posts
    6

    Difference between time in hours

    Dear All,
    Actually in Excel i have difficulty in finding the difference between two times.
    For example: assume that in 2000 i was working for around 16000 hrs 20 min 30 sec and in 2001, i have worked for 18000 hrs 45 min 13 sec (adding it from the previous year)
    Now i want to calculate (in cell B6) like how many hours min and sec i worked in 2001 since 2000 in the format hhhh:mm:ss and i want to plot this in graph in the form of hhhh:mm:ss in the y-axis and year in the x-axis.

    Kindly help!

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Difference between time in hours

    You can simple subtract the youngest date from the oldest date and format the result cell (B6) as [u]:mm:ss.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Difference between time in hours

    Hi cqwer,

    How your data appearing -
    16000 hrs 20 min 30 se
    OR,
    16000:20:30 ?

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  4. #4
    Registered User
    Join Date
    08-27-2010
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    76

    Re: Difference between time in hours

    Compared to 18000 hours, 45 minutes is insignificant. Why can't you just plot the hours?

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Difference between time in hours

    Agree with handerson0603

    Regards,
    DILIPandey
    <click on below * if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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