+ Reply to Thread
Results 1 to 5 of 5

How to have the time counting system activated?

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    Saipan,Northern Mariana Islands
    MS-Off Ver
    Excel 2007
    Posts
    7

    How to have the time counting system activated?

    In the game,I am trying to create, there is a need to count and display the number of passed hours between two events. Please,help me! Thanks!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: How to have the time counting system activated?

    What are the events? How do they occur? How are you using Excel?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    10-16-2012
    Location
    Saipan,Northern Mariana Islands
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How to have the time counting system activated?

    Hi,
    Thanks for the response,
    In a more complicated situation, the promised time (the first event) is,let us say, March12,2010 at 17:52 and actually something was done on this matter on November 7,2012 at 05:22(the second event). I do not know how let Excel to know that it is to count the number of hours (if needed,minutes,seconds etc) have passed between the two events.
    All my gratitudes,

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: How to have the time counting system activated?

    OK, so you already have two times in two cells and you need to know the number of elapsed hours, minutes, seconds (not days).

    If the earlier time is in A2 and the later time is in B2, use this formula:

    =TEXT(B2-A2,"h:mm:ss")

  5. #5
    Registered User
    Join Date
    10-16-2012
    Location
    Saipan,Northern Mariana Islands
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How to have the time counting system activated?

    Thanks a lot,Jazzer!
    I'll try now!

+ 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.6.0 RC 1