+ Reply to Thread
Results 1 to 6 of 6

Thread: Forumula for hours between dates

  1. #1
    Registered User
    Join Date
    10-13-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    2

    Forumula for hours between dates

    I've tried to copy and paste some formulas I've seen on the forum - but nothing's working. Basically I have two dates, let's say:

    10/10/11 4:34
    10/13/11 0:23


    I want to know the exact number of hours between them. This is for a health database, so it's not involving any "work" hours. Can anyone help?

  2. #2
    Extremely Helpful member
    Join Date
    12-23-2006
    Location
    Belgium
    MS-Off Ver
    XL2003
    Posts
    6,127

    Re: Forumula for hours between dates

    Hi and welcome to the board

    try =largest_value-smallest_value and format as [h]:mm:ss
    Quoting entire posts clutters the forum and makes threads hard to read !

    If you are pleased with a member's answer then use the Star icon to rate it

    Click here to see forum rules

  3. #3
    Valued Forum Contributor Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens Greece
    MS-Off Ver
    Excel 2003
    Posts
    2,285

    Re: Forumula for hours between dates

    Hi
    i was Preparing the same answer..

    Knowing that this is not the right place for my guestion, i apologize for it but i can't find(as new in the Forum), the way to send a new(my own) guestion.

    Please can you help me??
    Regards

    Fotis.

    I am proud that i am Greek.

    Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?

    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.


    My Avadar picture, is from Athens Acropolis.
    http://www.theacropolismuseum.gr

    http://www.visitgreece.gr/

  4. #4
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2007
    Posts
    10,052

    Re: Forumula for hours between dates

    Hello Fotis1991,

    To start a new thread go to the "Home page" of any of the forums, e.g. General here, and click on "New Thread" button
    Audere est facere

  5. #5
    Valued Forum Contributor Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens Greece
    MS-Off Ver
    Excel 2003
    Posts
    2,285

    Re: Forumula for hours between dates

    Hello again.

    Thank you very much for your answer.

    I appreciate it!
    Regards

    Fotis.

    I am proud that i am Greek.

    Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?

    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.


    My Avadar picture, is from Athens Acropolis.
    http://www.theacropolismuseum.gr

    http://www.visitgreece.gr/

  6. #6
    Registered User
    Join Date
    10-13-2011
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Forumula for hours between dates

    Thanks so much!

+ Reply to Thread

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.2.0