Results 1 to 5 of 5

Calculate time difference after 24hrs

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2009
    Location
    N.Ireland
    MS-Off Ver
    Excel 2003
    Posts
    76

    Calculate time difference after 24hrs

    I am having some trouble calculating a time difference between 2 times. I have started by using two columns that hold dates and i have a simple formula to calculate the difference in days between each date, this is fine. I know need 2 count the difference in hours between eg 10 Jul 09 @ 23:00hrs and 12 Jul 09 @ 13:30hrs. I am currently using the following formula but it doesnt count the hours if the time difference if its over two days:

    =U3-H3 +IF(H3>U3,1)
    Can anyone help?
    Last edited by PRodgers; 07-16-2009 at 04:57 AM.

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