+ Reply to Thread
Results 1 to 4 of 4

Difference Hours

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    Argentina
    MS-Off Ver
    Excel 2010
    Posts
    37

    Difference Hours

    Hi to all, I have a spreadsheet when some operator record time of entry and departure time. Example:

    Entry Time (A1) DepartureTime (B1)
    12:00:00 p.m. 5:30:00 p.m.

    Get that differences is easy because is in the same day; I use =(B1-A1) and the result was: 5:30 hours

    But my problem was when the departure time take place in the next day. Example:

    Entry Time (A1) DepartureTime (B1)
    9:00:00 p.m. 2:00:00 a.m.

    In this case I want to get as result: 5:00 hours.

    How can i do this?

    Thank you so much! Hope you can help me.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Difference Hours

    =MOD(B1-A1,1) should do the job
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    04-26-2013
    Location
    Argentina
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Difference Hours

    Great! thank you so much!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Difference Hours

    you're welcome and thanks for the Rep.

+ 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. 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
  2. Difference in Hours?
    By jimbofoxman in forum Excel General
    Replies: 4
    Last Post: 04-12-2007, 09:13 AM
  3. [SOLVED] How Do I Get The Difference In Hours and Mins
    By medicom06 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 PM
  4. [SOLVED] How Do I Get The Difference In Hours and Mins
    By medicom06 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  5. How Do I Get The Difference In Hours and Mins
    By medicom06 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  6. [SOLVED] How to get difference in hours
    By Akhilesh Dalia in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-23-2005, 02:06 AM
  7. Difference in Hours
    By Karan in forum Excel General
    Replies: 5
    Last Post: 04-21-2005, 07:06 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