| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating productivity: widgets per hour | Excel Worksheet Functions | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| Calculating number of instances occuring in an hour for 24 hours | Excel Worksheet Functions | |||
| Calculating a colmun to total a 40 hour work week | Excel Worksheet Functions | |||
| Calculating time worked using 100ths of an hour, from 1 day into n | New Users to Excel | |||
Threaded Mode
