Calculate call cost in seconds

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sheri - 12 Oct 2006 20:38 GMT

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

Reply to this Message

Gary L Brown - 12 Oct 2006 21:48 GMT

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,

Signature

Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

> 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
[quoted text clipped - 5 lines]
> Thanks,
> Sheri

Reply to this Message

David Biddulph - 12 Oct 2006 21:51 GMT

> 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
[quoted text clipped - 5 lines]
> 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.

Signature

David Biddulph

Reply to this Message