+ Reply to Thread
Results 1 to 4 of 4

Excel Time and Elapsed time formula

  1. #1
    Registered User
    Join Date
    06-27-2013
    Location
    United States
    MS-Off Ver
    Excel 2003 SP1
    Posts
    3

    Excel Time and Elapsed time formula

    Hello,
    I have need of some help. Thank you to anyone who replies or takes the time to read this. I am new in my Administration position and the biggest time suck is literally addition. I am not a lazy person however, I would like more time to make changes to the processes the previous admins in my position did not change for efficiency purposes.

    I would like to enter time into my excel database in basic number form using a 24 hour format into two cells. One for beginning and one for ending. I have been trying for a few hours to fix the end result. I cannot get excel to calculate the elapsed time if it exceeds a 24 hour period, or from evening to morning.

    for example: 1400 = A1, 0700 = A2. I would like A3 to calculate elapsed hours.

    If I need to put in the date, I can do this. Is there a way to enter the date in number format without the hashes, and excel read the date and time so it can calculate the elapsed time in hours?

    Thank you for your time and assistance.

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,959

    Re: Excel Time and Elapsed time formula

    Please Login or Register  to view this content.
    try this one
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    06-27-2013
    Location
    United States
    MS-Off Ver
    Excel 2003 SP1
    Posts
    3

    Re: Excel Time and Elapsed time formula

    Thank you for the formula! I cannot get the formula to work from one date to another though, do you have a way to write it so it will calculate across multiple days?

  4. #4
    Registered User
    Join Date
    06-27-2013
    Location
    United States
    MS-Off Ver
    Excel 2003 SP1
    Posts
    3

    Re: Excel Time and Elapsed time formula

    To clarify further:
    Currently I am using custom format of my cell as this, "00\:00 00\\00\\00." I type in 1645062513 to get out 16:45 06/25/13. I would like to take two cells that read something like the below two options, and calculate the elapsed time period in hours.
    A1= 1645062513, which reads: 16:45 06/25/13
    A2= 0745062613, which reads: 07:45 06/26/13

    Is there a way I can take the elapsed time from these two dates? I do not mind inputting my data differently however, it would be nice to streamline the input to just numbers. Thank you all again for your time and assistance.

+ 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