A2 = # of seconds in a call
B2 = # of calls with that # of seconds
C2 = # of total seconds for the calls
=(+A2*B2)*60*60*24

Add all Column C figures.
Multiply THAT # by $.02.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Sheri" wrote:

Hi: This is giving me a headache. I have time formatted as hh:mm:ss, the
data contains entries with minutes and seconds and just seconds. I need to
multiply the number of seconds of each call by the number of calls to arrive
at number of seconds then take the number of seconds and multiply by $.02 to
determine the total cost. Everything I try gives me strange results, the
numbers don't look right. Can anyone help?

Thanks,
Sheri