| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i convert a value quoted in hrs,mins,secs to just mins
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i convert a value quoted in hrs,mins,secs to just mins
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 The man from delmonte wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
| How do I convert hours and mins into just minutes in excel? | Excel Worksheet Functions | |||
| How to convert numeric value to mins and addimg mins to Hrs. | Excel Worksheet Functions | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Linear Mode
