 calculating transactions per second and per hour Index ‹ Excel ‹ Excel Programming
Author Message   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 date-time value. 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. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, 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 > >  Index ‹ Excel ‹ Excel Programming