calculating transactions per second and per hour



I am loading a transaction log into an excel spreadsheet which consists of a
number of date/time stamps for different activities that occur during a
transaction run.
So it would be something like
Cell A1 Start of run
Cell A2 End of first phase
Cell A3 End of second phase
Cell A4 Number of records in run
etc until
Cell A9 Finish of run

I then calculate the durations for each phase, which is a simple date
Now I want to work out the transactions per second and per hour for each
phase which will be the Number of records in run divided by the duration, but
how do I get the duration from an hh:mm:ss to just seconds or just hours?

Tushar Mehta

The easiest way is to exploit knowledge of how XL stores a date-time

A date-time is stored with the date to the left of the decimal point
and the fraction part containing the time. So, if your duration value
is in cell A10, the formula =A10*24 will give you the number of hours.


Tushar Mehta
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions




If your duration time value is in cell B1 then:
Duration_days = B1
Duration_hours = B1*24
Duration_minutes = B1*24*60
Duration_seconds = B1*24*60*60

The formats of the cells need to be one of the numeric formats (not
Date/Time) to display properly.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question