Results 1 to 3 of 3

calculate number of hours between two date/time combinations

Threaded View

smokebreak calculate number of hours... 01-21-2010, 10:42 AM
DonkeyOte Re: calculate number of hours... 01-21-2010, 11:05 AM
smokebreak Re: calculate number of hours... 01-21-2010, 11:09 AM
  1. #1
    Registered User
    Join Date
    12-15-2009
    Location
    Houston, TX, USA
    MS-Off Ver
    Excel 2007
    Posts
    86

    calculate number of hours between two date/time combinations

    Hello,
    I am trying to find a way to calculate the number of hours between date/times found in separate rows. The attached data set will help to envision what I am talking about.

    For each couple of rows, I need to find a way to calculate the number of hours elapsed from row 1 to row 2. In the first example, to calculate the number of hours between 12/2/2009 8:56:51 and 12/4/2009 6:35:27.

    any help is appreciated!

    Thank you
    Attached Files Attached Files
    Last edited by smokebreak; 01-21-2010 at 11:10 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