Calculate call cost in seconds
 

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

Calculate call cost in seconds
 

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

Calculate call cost in seconds
 

"Sheri" wrote in message
...
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?

If you've got A1 formatted as hh:mm:ss, then =A1*24*3600 will give you time
in seconds, and you can multiply that by number of calls, and by your cost
per second.
--
David Biddulph