calculating transactions per second and per hour 

Author 
Message 
Pipeladylu

Posted: Fri Mar 18 06:17:38 CST 2005 
Top 
Excel Programming >> 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
subtraction.
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?
Thanks
Excel156





Tushar

Posted: Fri Mar 18 06:17:38 CST 2005 
Top 
Excel Programming >> calculating transactions per second and per hour
The easiest way is to exploit knowledge of how XL stores a datetime
value.
A datetime 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.

Regards,
Tushar Mehta
www.tusharmehta.com
Excel, PowerPoint, and VBA addins, tutorials
Custom MS Office productivity solutions
> 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
> subtraction.
> 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?
> Thanks
>
>
>





TroyW

Posted: Fri Mar 18 06:26:04 CST 2005 
Top 
Excel Programming >> calculating transactions per second and per hour
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.
Troy
>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
> subtraction.
> 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?
> Thanks
>
>






