G
Guest
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
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