Thanks:  0
Likes:  0

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

1. ## 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. ## 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. ## 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!

## User Tag List

#### Posting Permissions

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