Dividing by time

  • Thread starter Thread starter Kamadeca
  • Start date Start date
K

Kamadeca

I hope I have a simple question with a simple solution.

Problem: I need to figure out how many transactions are
completed in a given period of time. Here is my example:

330 transactions in 29 minutes and 32 seconds.

When I enter the time as 0:29:32 and try and divide I get
an erroneous answer.

My question: How do I enter the time and or how do I
structure the formula to give me the correct answer.

Thanx
 
It depends on what unit of time you are measuring.

For transactions per hour, use
=transactions / (time * 24 )
For transactions per minute, use
=transactions / (time * 24 * 60)
For transactions per second, use
=transactions / (time * 24 * 60 * 60)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top