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

  • Thread starter The man from delmonte
  • Start date
T

The man from delmonte

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?
 
V

vezerid

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative time calculation in Excel 2003 3
Time Sum in Excel 1
Value converted to hours and mins? 2
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Format Cells for Mins / Secs 2
Convert minutes to hours and mins 5
Excel Rounding of Formular results 1
converting seconds to mins 2

Top