Dividing numbers by time values

[JamesPH]

I am trying to calculate a total number of records processed per second
from a process log.

I have minused the start time from the end time and used the custom
format [ss] for the total. This shows the total number of seconds the
process has taken to run (rather than hours, minutes and seconds). I
have also summed the total number of records processed.

I now need to divide this number by the total seconds calculated
above.

As the seconds are a time value and not a numeric value, this dividing
returns a completely meaningless number.

For example:
process start time = 11:14:06
process end time = 11:16:19

11:16:19-11:14:06 = 131 (when the totalled cell is formated as [ss])

Lets say the total number of records processed is also 131, the total
records processed divided by total seconds taken should equal 1.

Any ideas as to how I use the time value as it appears (i.e. 131) in
another formula, rather than it's underlying value...?

 

[Pete_UK]

Time is stored internally by Excel as a fraction of a 24-hour day, so
you are actually dividing by a very small fractional value rather than
131 seconds. To rectify this you need to multiply your value by 60, by
60 and by 24 (i.e. your _formula*60*60*24).

Hope this helps.

Pete

 

[Bob Umlas]

Multiply the result by 86400 (the # of seconds in a day) and format the
result as General. You'll have the right answer.
Bob Umlas
Excel MVP