Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: calculate number per hour using total time divided by total number

  1. #1
    New Member
    Join Date
    Apr 2009
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default calculate number per hour using total time divided by total number

    How do I calculate the number of batches per hour? Here's what I have so far:

    Cell B5: start time: 4:15 formatted as 4:15:00 am
    Cell B6: finish time: 6:15 formatted as 6:15:00 am
    Cell B7: total time: 2:00 formula in cell: =TEXT(B6-B5,"h:mm")
    Cell B8: total batches processed: 22 (this is entered manually)
    Cell B9: batches per hour: formula in cell: =B8/TEXT(B7,"h")

    as long as I have this formula in cell B9 the answer comes out correct which should be 11 per hour.
    If the formula in B9 is B8/B7, the answer is 264.0, Is this because of the way excel is reading the total time or the total time is formatted as a time, not an actual number? Is this the correct way to solve the problem?
    answer should be 11 per hour.

  2. #2
    Board Regular
    Join Date
    May 2008
    Posts
    836
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: calculate number per hour using total time divided by total number

    Regi,
    welcome to the board.

    Try B7 = B6-B5 with time format and
    B9 = B8/(B7*24) with general format

  3. #3
    New Member
    Join Date
    Apr 2009
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: calculate number per hour using total time divided by total number

    Hi: Thank you so much for the quick response. Guess I was really thinking to hard on this one......this website is GREAT! Sure I will be using quite a bit in the future.

    Anyway, can you explain to me the logic behind using this formula. Just call me "super anal retentive"! Gotta know how everything works!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •