how can i convert a value quoted in hrs,mins,secs to just mins

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The man from delmonte - 17 Oct 2006 10:41 GMT

I want to calculate the cost of phone calls where I have the duration in Hrs,
mins and secs and I also have the cost per minute. Do i need to convert to
minutes only first?

Reply to this Message

vezerid - 17 Oct 2006 11:12 GMT

If A2 holds the duration in hh:mm:ss and B2 holds the cost per minute,
then the total cost is given by:

=A2*24*60*B2

If a conversation of, say, 30 seconds is charged as a full minute then
you need

=CEILING(A2*24*60,1)*B2

HTH
Kostis Vezerides

> I want to calculate the cost of phone calls where I have the duration in Hrs,
> mins and secs and I also have the cost per minute. Do i need to convert to
> minutes only first?

Reply to this Message